technologyssam.blogspot.com

MS Excel Short Keys Short KeyDescriptionCTRL+(Unhides any hidden rows within the selection.CTRL+)Unhides any hidden columns within the selection.CTRL+&Applies the outline border to the selected cells.CTRL+_Removes the outline border from the selected cells.CTRL+~Applies the General number format.CTRL+$Applies the Currency format with two decimal places (negative numbers in parentheses).CTRL+%Applies the Percentage format with no decimal places.CTRL+^Applies the Exponential number format with two decimal places.CTRL+#Applies the Date format with the day, month, and year.CTRL+@Applies the Time format with the hour and minute, and AM or PM.CTRL+!Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.CTRL+-Displays the Delete dialog box to delete the selected cells.CTRL+*Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).CTRL+:Enters the current time.CTRL+;Enters t...

Practice make man perfect Excel Rows and Columns Spreadsheets are displayed in a grid layout. The letters across the top are Column headings. To highlight an entire Column, click on any of the letters. The image below shows the B Column highlighted: If you look down the left side of the grid, you'll see numbers, which start at number 1 at the very top and go down to over a million. (The exact number of rows and columns are 1,048,576 rows and 16,384 columns. You've never going to need this many!) You can click a number to highlight an entire Row. If you look at the image below, you'll see that Row 5 has been highlighted (The image is from Excel 2007. Later are version are the same except less colourful!). Spreadsheets are all about individual Cells. A Cell is a letter combined with a number. So if you combine the B column with Row 5, you get Cell B5. Combine Column D with Row 5 and you get Cell D5. To see this for yourself, click inside any of the cells on your spread...