Microsoft Excel Handy hints

A little while ago we did a tip of the week for useful short cuts which can be used in most windows applications. This follow-up will mostly follow the same suit but focused more on Microsoft Excel.
General Short Cut Keys

CTRL + O – Open a document.
CTRL + S – Save a document.
CTRL + P – Print a document.
CTRL + C – Copy highlighted text or the current cell.
CTRL + V – Paste Text or a cell.
F12 – Open the ‘Save As’ dialog box.
Ctrl + B – Apply or remove bold formatting.
Ctrl + I – Apply or remove italic formatting.
Ctrl + U – Apply or remove an underline.

Navigating Worksheets

Arrow Keys – Move one cell up, down, left, or right in a worksheet
Page Down/Page Up – Move one screen down / one screen up in a worksheet.
Alt + Page Down/Alt+Page Up – Move one screen to the right / to the left in a worksheet.
Tab/Shift+Tab – Move one cell to the right / to the left in a worksheet.
Home – Move to the beginning of a row in a worksheet.
CTRL + Home – Move to the beginning of a worksheet.
CTRL + End – Move to the last cell with content on a worksheet.
CTRL + F – Display the Find and Replace dialog box (with Find selected).
CTRL + H – Display the Find and Replace dialog box (with Replace selected)

Data Selections

Shift + Space – Select the entire row.
CTRL + Space – Select the entire column.
CTRL + A (or CTRL + Shift + Space Bar) – Select the entire worksheet or the data-containing area. Pressing CTRL + A a second time then selects entire worksheet.
CTRL + Shift + Page Up – Select the current and previous sheet in a workbook.
CTRL + Shift + O – Select all cells with comments.
Shift + Arrow Keys – Increase or decrease the selection by one cell.
CTRL + Shift + Arrow Key – Extend the selection to the last cell with content in row or column.
Shift + Page Down/Shift + Page Up – Extend the selection down/up one screen.
Shift + Home – Extend the selection to the beginning of the row.

Handy Tips to Know

• If you select two or more cells in which contain figures. In the bottom right hand corner of the window Excel will show you the average, count and sum of the cells selected.
• If you have multiple rows or columns which you need to know the total sum of, selecting them with a set of blank cells (at the bottom for columns or right hand side for rows) will allow you to use Excel’s ‘Auto Sum’ which is found on the right hand side of the Home ribbon. This will automatically calculate the total of each row or column. Selecting blank columns at the right and bottom will automatically calculate all rows and columns.
• If you have data in your spreadsheet or even in your workbook which you do not want to be edited or accidentally deleted then you can protect it with a password. Heading over to the Review ribbon, on the right hand side you will see ‘Protect Sheet’ and ‘Protect Workbook’. they both work exactly as they’re titled and you can password protect the data you don’t want changed. WARNING! Forgetting the password you set will cause big problems as there is no override, so be sure to make it a memorable one.