Make your life easier, use shortcut keys in Excel.
Shortcut keys can make your time on Excel much more efficient. Reaching for the mouse or touch pad to do something is definitely slower than using a shortcut key. Also, some of the best shortcut keys saving typing time and are more accurate. It can take a bit of time to get used to using […]
Much more efficient manual entry
As much as I like to automate tasks, and avoid manual entry, sometimes it is unavoidable. But when it is required, it too can be done in an efficient or inefficient way. I see people type into one cell, then use their mouse to click in the next cell to enter the next piece of […]
New Window on the world, or at least on your spreadsheet.
When you want to see two parts of your spreadsheet at once, New Window is what you want to be using. Found in the View menu, in the Window Section. (Shortcut keys Alt, W, N) Activating New Window will open another window to the current workbook almost as if it was another workbook. So now […]
Side by side (With thanks to Harry M. Woods)
You can view two workbooks side by side and scroll them together. Very handy if you are comparing them. View Menu, Window Section, View Side by Side. (Shortcut Alt, W, B) If you have more than one other workbook open, you will then get to choose which workbook you would like to put side by […]
Split: See your spreadsheet differently.
When you want to view two different parts of your spreadsheet at once, you can use Split. Split is found in the View Menu, Window Section. (Shortcut Key Alt, W, S) Split will cut your spreadsheet into four based on the current active cell. Scroll up and down will move both the left and right […]
Easily add names for cells.
I have written about naming cells and why it is a good idea before. Here is an easy way to do a whole lot of those at once. Your data has to be set out in a particular way. I have a small example here. Select all the data, from the Income cell to the […]
What is faster than scrolling? Jumping. Go To…
Home menu, Editing section, Find & Select, Go To… or Shortcut key Ctrl + G, or F5. You can type in a cell reference, click OK and be taken right there. You can use it to jump to another sheet, but have to type in the name of the sheet, then !, then the cell […]
I still haven’t found what I am looking for… solved.
Hiding under the Find & Select drop down is Go To Special… Find & Select, can be found on the Home Menu and is the Editing section. Click on the drop down and choose Go To Special… This powerful little tool can be very handy when you are looking for particular parts of your spreadsheet. […]
Excel App – productivity on the go – Card View.
To make it easier to read data on a smaller screen, you can use Card View on the Excel app. Your background data needs to be in a table for it to work. Here is the table view of the data And, here is the Card View How to select Card View. Once in Card […]
Make your life easier: give a cell a name.
You can give a cell a name in excel. So, rather than being called A5 or E3 the cell could be GST or Total. This makes you formulas easier to understand. See below in the formula bar for an example, this means more than E10+E23+E34+E40. This also means you can use the name box to […]