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 […]