Then, you activate the shortcut by pressing the Alt key and the number it’s assigned to. Without inserting a formula in the formula bar you can directly total the row or the column by just clicking on AutoSum. AutoSum helps to total up various rows and columns in the spreadsheet. When you want to total a particular row or column you use this function. It helps to carry out the task at a great speed. If you are in a table then pressing the CTRL+A key selects the data excluding theĪutoSum is the most powerful feature in Microsoft Excel. If you press CTRL+A a second time in the same range selects the entire spreadsheet. If you are in regular data range and press CTRL+A all the data is selected. If you are in a table then pressing the CTRL+A key selects the data excluding the ![]() ![]() CTRL+TAB Switches between open Excel windows. Microsoft excel shortcut keys and formulas pdf
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |