It can be very fiddly to manually adjust the height and width of a cell in an Excel spreadsheet with the mouse, and pretty much impossible with the keyboard. It is also difficult to know what the size of a cell should … Read More
You can move to the Taskbar in Windows by pressing Windows key + T. Once focused on the Taskbar, press Alt + Enter and this will take you straight to the settings page for the Windows Taskbar. This is particularly … Read More
An easy way to insert and delete rows or columns in Excel: Press Control + Plus (Control + Shift + Equals) to bring up the Insert dialogue. Press Control + Minus to bring up the Delete dialogue. If you select a column or row … Read More
In Excel, you can give your spreadsheet a title, and then centre it across a number of columns so that it is placed over the data that it refers to. Type in your heading in a cell in the top left … Read More
If you want to duplicate an entry across a range of cells, first select the range of cells, then type in the entry and then press Control + Enter. This will duplicate the entry across the whole selected range. Ideal for copying … Read More
As we know, when we edit a cell, pressing Enter accepts the information and moves off the cell. But what if you want to add another line of text in the same cell? Press Alt + Enter to add a new line, … Read More
As we know, by default, pressing Enter after editing will move to the cell directly below. Whereas, pressing Tab after editing will move to the cell directly to the right. If you press Shift + Enter after editing, Excel moves … Read More
It can be useful to insert links within an Excel spreadsheet. It can be a link to the Web or a link to open another file. The shortcut is the same for all Microsoft applications: Control + K. This opens an … Read More
Excel cell notes are used to put some extra information in a cell, like a description of the data in that cell or an explanation of a formula in the cell. This is very useful, especially for users are not … Read More
By default in Excel, a cell aligns to the left for text and to the right for numbers. We can access all the alignment options in the Format Cells dialogue (Control + 1, then Control + Tab to move to … Read More