Simply press Ctrl+; (hold down the Ctrl key and then type a semi-colon at the same time), and then press Enter. This time stamps the date into the cell ... that is, it's a value that won't change. To have a dynamic entry of today's date that updates every day, enter
=TODAY()
instead.
Press Ctrl+: ( hold down the Ctrl key and then type a colon at the same time, which, on a UK keyboard is Shift+; ... so the combined key press is Ctrl+Shift+;), and press Enter. Note that this only adds a time-stamp, and does not include the date. To have today's date AND the current time entered as a value into the active cell, combine the date stamp shortcut with the timestamp shortcut by using them one after another separated by a space ... date and time stamp = Ctrl+; then Space then Ctrl+Shift+; then Enter. To have a date/time update automatically, enter
=NOW()
instead.
To enter the same text, or number, or formula, into the currently selected range of cells, press Ctrl+Enter instead of Enter.
To navigate from tab to tab in a workbook that has multiple tabs, use keyboard combination Ctrl+Page Down to go to the next tab, and use Ctrl+Page Up to go to the previous tab.
If you are in a list of cells with data, and you want to Filter the list, a quick way of enabling Filtering is to use the keyboard combination Ctrl+Shift+L and hey presto, Filtering is on. This is a toggle action, so do the same again to remove Filtering.
To create a new workbook directly from the keyboard, press Ctrl+n
Pressing Shift+Space selects the entire row(s) of the currently active cell/selection.
Pressing Ctrl+Space selects the entire column(s) of the currently active cell/selection.
These shortcuts are really useful when you are altering the layout of worksheets, as they enable you to select entire rows or columns, after which you can insert/delete/copy/paste the selection. See the Copy/Insert/Delete/Insert-Paste shortcut notes for useful hints to combine with these shortcuts.
To copy a cell/range/object into the clipboard, press Ctrl+c (that is c for Copy)
To cut a cell/range/object into the clipboard, press Ctrl+x (x could remind you of a pair of scissors, or you could think of the word eXtract, or eXcise, instead to remind you of this)
To paste whatever is in the clipboard, press Ctrl+v (v is similar to the marking in manuscripts to show where additional text is supposed to go, if that is of any use to you as a reminder)
To insert a copied range or cell, shifting other cells, use Ctrl+Shift+"+" (press Ctrl and Shift and use the "+" sign on the keyboard, which is Shift+"=" on a UK keyboard, so Ctrl+Shift+"=" is the actual key sequence).
To Paste cell contents as values (instead of formulas), use Alt+ESV then Enter (Alt+ES brings up the Paste Special dialog, and V chooses the Values radio button, and pressing Enter completes the action - the same as pressing the OK button.
To delete a cell/selection press Ctrl+"-" (press Ctrl and the minus-sign at the same time). When deleting cells, and not entire rows or columns, you will be prompted as to which operation you require, Shift Cells Left or Shift Cells Up (or Entire Row or Entire Column). To clear a selection (delete contents), simply press the Delete key.
Combining these actions with the action of selecting rows or columns allows for quick and easy layout changes within a worksheet. For example, if you want to move the contents of column C, and place them before the current contents of column B, select any cell within column C, press Ctrl+Space, then Ctrl+x, then left arrow to select a cell in column B, press Ctrl+Space, and then Ctrl+"+" and the alteration is complete. (actions are, in sequence: select entire column C, Cut, select entire column B, insert cut cells)
Note: these shortcuts are very useful for when your fingers are already on the keyboard, and you want to complete an action without having to switch to the mouse. If your hand is already on the mouse then there are actions via the mouse that are as useful as these shortcuts. These are covered in the next section.
Just to cover the basics, to move a cell/selection, left-click on the edge of the selection and drag, and the cell/selection is moved to wherever you've dragged and dropped it to.
To copy a cell/selection, drag with mouse combined with right-click, and when dropping at the destination cell, a context-menu is shown, and from that choose Copy Here.
To copy a cell/selection to a location that is not on-screen (i.e. where dragging is not possible), then right-click with the mouse, and choose Copy from the context-menu, then navigate to the required destination, and right-click again, and then click on the paste icon ... note that after copying and navigating, pressing Enter will also paste.
To copy a cell/selection with the mouse, in combination with the keyboard, drag while holding the Ctrl key down, and drop ... this is the complete operation to copy in this way!
To copy/paste values for a cell/selection, right-click and drag the selection, and drop. A context-menu will display .... choose option Copy Here As Values Only.
To convert a cell/selection to values, do a something similar to ordinary copy/paste values .... right-click and drag the selection, but then drag it back over it's original position and drop. The context-menu will display .... choose option Copy Here As Values Only.
Basic mouse operations for selecting an entire row or column is to left-click in the row or column header.
To display the context-menu for an entire row or column, select the header using right-click. This gives options including Insert and Delete, Cut and Copy, Hide and Unhide.
If you want to move the contents of column C, and place them before the current contents of column B, select entire column C, using right-click in the column header, and choose Cut from the context-menu. Next select entire column B, using right-click in the column header, and choose Insert Cut Cells from the context-menu. And hey presto, it's done!
If you want to move the contents of column C, and place them before the current contents of column B, using drag and drop, you need to use the keyboard at the same time, but it is SO easy an operation to perform when designing worksheet layouts, that I use it all the time! Here is how ... select entire column C using left-click in the column header, then left-click the edge of the selected column (note: not in the header area), then hold down the Shift key and start dragging ... you will see a vertical grey bar appear between columns that you are dragging over, then drop into the required location (that is, release the mouse button).
Move a column using the mouse to drag (holding Shift key at same time). This video clip does not have audio.
King Of Excel
Copyright © 2021 Glenn Bamford - All Rights Reserved.
Powered by GoDaddy Website Builder