Microsoft Office and Excel: top tips and fast learning

Excel in 100 Tweets 8: Applying Borders

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

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

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

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

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.