Suppose I have a numeric data range, so I want to do a sum up for that data range, to perform this task at a faster pace, you need to select the data range.Īfter pressing on the “ALT key and Enter”, it will give the range’s total value. (Note: for example, if you want to insert ten columns or rows, you need to select the same number of rows or columns and then do a right-click & select the Insert option so that ten rows or columns get inserted. so automatically, the rows or columns get inserted. In some cases, you want to insert additional rows or columns, to add extra datasets for this, you need to select or highlight the columns or rows, do a right-click & select the Insert option. Addition or insertion of multiple columns or rows Suppose you are entering address details, you need to add multiple lines of data in the same cell, for that, you need to enter short cut key “Alt + Enter”, it will move the cursor down so that you can enter or type the text in the next line.ĥ. Insert a Comment: Short cut key will be SHIFT + F2 (Note: Prior to performing this, double click on cell reference for edit mode). In some scenarios, we need to enter today’s date & time instead of looking into the calendar or time at the bottom, we can use the below-mentioned shortcut key.įor date: CTRL + or For time: SHIFT + CTRL +
Insertion of Date or Time or Comments in Excel ALT + HOH (Column Height) & ALT + HOW (Column Width)ģ. When you are working on a huge data set, this column width adjustment and its resizing is important, here you have to select the multiple columns, then you need to hover your cursor of mouse towards the right side of the column where you want to resize it and double click on it to get the desired result, or you can use shortcut keys, i.e. Selection of all the data with a single click or with the help of CTRL + A helps out to select a whole data range in a worksheet. You can download this Excel Hacks Template here – Excel Hacks Template Example #1 – Use of Important Keyboard Shortcuts
0 kommentar(er)
