If you want to add an outer border or outline around the selected cell then just use this shortcut. By doing so, it will ask you where the data on your table is and your excel table will get created automatically. Use these shortcut keys that will let you insert table. To select multiple rows you need to hold Shift along with up/down arrows. To save much time, select the entire row. Using Shift and arrows, you can select multiple columns. Selecting the complete columns is also a timesaver. If you do not want the cell formula and just require values then you can use this above shortcut.įor Mac, ^+Upper arrow+” Select Entire Column If you want to hide columns then you can use these shortcut keys that will save your time in hiding columns.
Click up and down arrows to check the option.įor Mac, Ctrl+F Copy formula from above cellĬopying formula from the above cell will give you an exact copy of formula whereas the cell references will not change. If you want to search any item or function then just press Ctrl+F and type the keyword. To save your timeĪ hyperlink is used for redirecting the keyword to its destination.
If you want to add current date in a cell, then you need to apply a formula. If you want to enter current time then no need to use any formula just use this shortcut
