Excel in 100 Tweets 7: Formatting Dates - To get the date to look how you want select the option from the Number Format drop down to show either the short date (dd/mm/yyyy) or the long date (dd mmmm yyyy)
Excel in 100 Tweets 8: Applying Borders - To apply borders around your highlighted cells, right-click and use the Border tool on the mini-toolbar to make your choice. Use the option More Borders... to get more control.
Excel in 100 Tweets 4: Formatting Text - To get the text to look how you want, select the cells and right-click to show the mini-toolbar which has buttons to set font, size, colour, bold, italic and underline.
Excel in 100 Tweets 2: Navigation - Ctrl+Home takes you to A1. Ctrl+End takes you to bottom right. Home takes you to first cell on the current row. Ctrl+Arrow takes you to the end in that direction - use Ctrl+right arrow to go to the end of the row.
Excel in 100 Tweets 3: Confirming a Cell Entry- When you've finished typing press Enter or an arrow key. The arrow keys will take you in the direction of the arrow. Use the Tab key to go across a row and then enter at the end to go down a row and back across to where you started.
Excel in 100 Tweets 1: Basic Editing - Select a cell and start typing. Press Enter when finished or Esc to cancel and start again. Don't click away when finished, sometimes this will put the cell reference into the cell so is a bad habit.
Add to QAT: The Quick Access Toolbar is the little row of icons at the top-left of #Excel #Word etc. Add icons to it by right-clicking the command on the ribbon and picking Add to Quick Access Toolbar.
A quick introduction to the Format Painter tool. The demo is in Microsoft Excel but the principles are the same in Word, PowerPoint, etc.
Select Region: Want to select a block of cells in one go. Press Ctrl+* (or Ctrl+Shift+8). Don't forget that many commands like sorting or creating a table don't need the region to be highlighted first #Excel #Microsoft