Earlier this week, I copied a list of Excel keyboard shortcuts from the Microsoft website, and pasted it into Excel. Then I noticed that a few objects had come along with the shortcuts list.
In the screen shot below, you can see one of the tiny icons that you can click, to go to the top of the web page. Those are handy on the web page, but aren’t much help on the Excel sheet.
See What Objects You Copied
Sometimes these objects are easy to spot, but if they’re small, or if there are lots of them,
Continue reading Quickly Clear Objects from Worksheet
If you want to insert a block of cells on a worksheet, what method do you use?
One way to insert cells is to select some cells, right-click on the selected range, and click Insert. Then you can select one of the Insert options.
Insert With the Fill Handle
This week, I was doing some updates on this blog, and found a tip that I posted 5 years ago. You can use the Fill Handle as a shortcut for inserting and deleting cells.
Select cells as a starting point, press Shift, and drag the fill handle to insert
Continue reading Insert Rows with Excel Fill Handle
One of the new features in Excel 2013 is that each file opens in a separate window. Having each file in its own window makes it easier to compare files side-by-side, and most of the time I like the separate windows.
One thing that I don’t like is that, unlike previous versions, there is no Exit button or command, to close all the files. Each window has its own Close button, and if you’ve got lots of files open, it’s a pain to close each window individually.
Use the Taskbar Command
One solution is to use the Close
Continue reading Close All Files in Excel 2013
As you’ve heard, Google Reader will be disappearing in a few months <sigh>, and we’ll have to find other ways to follow our favourite blogs. I’m looking for a replacement, but haven’t found anything perfect yet. How about you?
In the meantime, I can at least list a few RSS feeds in Excel, by using some built-in tools. In the video below, you can see how I created a list of articles from this blog, using an XML map.
Create the RSS Feed List
It’s easy to create an RSS feed list on a worksheet, as long as you
Continue reading Show RSS Feeds on Excel Worksheet
In Excel, you can create named ranges, and go to those ranges by selecting a name from the Name Box.
In addition to those permanent names, you can also store up to 4 temporary locations, and to back to those locations quickly. This is handy if you’re making updates to a big workbook, and want to switch between a couple of sheets quickly, without lots of scrolling.
Temporarily Store a Location
Here are the steps for storing a location:
Select a cell on the worksheet Click in the Name Box, which is to the left of the Formula Bar
Continue reading Go Back to Previous Locations in Excel
In Excel 2013, if you click the File tab, you go to the Backstage view. The Open command is selected, and you can select a file and open it.
You can also add an Open icon to your Quick Access Toolbar (QAT).
If you point to that icon, after adding it to the QAT, the screen tip says “Open”.
Click that icon, and it also takes you to the Backstage view, just like the File tab does.
If you want to see files that aren’t listed in the Recent list, you can click Computer, then click the
Continue reading Show the File Open Window in Excel 2013
If you’ve been using Excel 2013, you might enjoy seeing the collection of templates when you open Excel.
There is a blank template at the top left, and you can even take a tour of Excel.
There is a wide assortment of templates to choose from – everything from a balance sheet to a vacation checklist.
Turn Off the Start Screen
It was interesting to see those templates the first time that I opened Excel 2013, but 100% of the time I click on the Blank Template.
Instead of having to click on it, I’d like a blank
Continue reading Open Excel 2013 With a Blank Template
Things have been hectic this week. I got a new laptop, with Window 8, and have spent hours installing software, and getting all my settings the way I like them.
I’ve also installed the latest version of Excel 2013, and am using it for my daily work, so there’s lots of new stuff to play with and learn.
Add a Picture to an Excel Comment Update
While moving files to my new computer, I’ve found a few things that need updating, like this Picture in a Comment video. I made the previous video in May 2008, when Excel still
Continue reading Add a Picture to an Excel Comment
What's a quick way to combine the items in two table? For example:
Table A has 3 items – Sugar, Coffee and Milk. Table B has 2 items – Cans and Sticks.
How can you create a third table that has all the Table 1 items combined with each of the Table 2 items?
Sugar – Cans, Sugar – Sticks, etc.
Use MS Query
I've done this with programming before, but this time I used Microsoft Query, to do the work for me.
Add the two tables to the query, with no join line between them,
Continue reading Create Table Combinations With MS Query
Do you have your party plans finalized? Remember, tomorrow, October 17th, is Spreadsheet Day, in honour of the date that VisiCalc was first shipped.
Last year, the theme was spreadsheets for students, and I posted a student time tracker in which you can plan your projects and track your class and lab hours.
In 2010, I posted my top 5 Excel tips, that I had seen posted on Excel blogs over the previous year. One of those tips was Jon Peltier's tutorial on making vertical bullet graphs.
Top 5 Excel Tips for 2012
This year, I'm going back
Continue reading Spreadsheet Day 2012