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 […]
Save time: Link to a cell
You can insert a link within excel. This link could be to a web site, or a place within the spreadsheet. That way you can navigate around the worksheet or even to a different sheet without lots of scrolling and clicking. If you have a large sheet or a workbook with a lot of sheets […]
Quick Information: Use the Status Bar
In the bottom right hand corner of your excel sheet is the status bar. When you highlight a group of cells the status bar tells you some information about them, such as the average, count(how many cells are highlighted) and the sum. You can add extra pieces of information to show here by right clicking […]
Top ten shortcut keys in Excel
Ctrl+; —Inserts today’s date.Ctrl+Shift+:—Inserts the current timeCtrl+0— Hides the current column.Ctrl+9—Hides the current row.Ctrl+`—That’s the accent mark, up by the 1 key. Toggles the view in the sheet to show all the formulas or cell values.Ctrl+PageUp or PageDown—Moves to the next worksheet in the currently open workbook.F2—Start editing the current selected cell.Shift+F10—Opens the right-click menu for the cell […]