To add rows, columns, or cells in Excel, right-click the relevant row number, column letter, or cell, then choose Insert, and select "Sheet Rows," "Sheet Columns," or "Shift cells down/right". You can also use the Home tab > Cells group > Insert options, or keyboard shortcuts like Ctrl+Shift++ after selecting rows/columns. For cells, you choose whether to shift existing content down or right.
If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you're done. When you select AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
Ctrl+' Copies a formula from the cell above the active cell into the cell or the Formula Bar. Ctrl+- Delete the selected column or row Ctrl+~ Switch between showing Excel formula or their values in cells. Ctrl+1 Displays the Format Cells dialog box. Ctrl+2 Applies or removes bold formatting.
You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10. =SUM(A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.
In Microsoft Excel, Ctrl+F12 is a shortcut that opens the "Open" dialog box, allowing you to browse for and open an existing workbook file, similar to going to File > Open. It's a handy way to quickly access your saved files without using the mouse, though on some laptops you might need to press Ctrl + Fn + F12.
How to create a running total in Excel
The Autosum Excel shortcut is very simple – just type two keys:
Alt+= is a keyboard shortcut most commonly used to create a formula to sum all of the above cells in a Microsoft Excel spreadsheet. Below are other programs that use this keyboard shortcut and related information.
The 7 basic Excel formulas, essential for any beginner, include SUM, AVERAGE, COUNT, COUNTA, IF, MAX, and MIN, which handle totaling, finding the mean, counting numeric/non-blank cells, applying logic, and identifying extremes within data sets, with AutoSum being a shortcut for SUM and TRIM useful for text cleaning, making these foundational tools for quick data analysis.
Ctrl+R is a keyboard shortcut that is commonly used in web browsers to reload the current webpage.
In Excel, Ctrl+F5 typically refreshes external data connections in the current worksheet, keeping imported data up-to-date, though it can also restore a maximized workbook's window size to its previous dimensions. For broader data refresh, Ctrl+Alt+F5 updates all worksheets, while simply pressing the F5 key opens the 'Go To' dialog for navigation or 'Go To Special'.
How to turn on auto calculate in Excel
Enter your data
Here's a formula that uses two cell ranges: =SUM(A2:A4,C2:C3) sums the numbers in ranges A2:A4 and C2:C3. You'd press Enter to get the total of 39787. To create the formula: Type =SUM in a cell, followed by an opening parenthesis (.
Some of the most commonly used function key shortcuts include: F1 to display help or the Office Assistant, F2 to edit the active cell, F3 to paste a name or function into a formula, and F4 to repeat the last action. F5 allows you to go to a cell or find data, F6 moves between panes, and F7 performs a spelling check.
The Ctrl + F4 keyboard shortcut is primarily used to close the active tab or window within an application, making it great for quickly closing one document or webpage without exiting the whole program, unlike Alt + F4, which closes the entire application. In web browsers, it closes the current tab; in programs like Microsoft Excel, it closes the active workbook, leaving Excel open.
Ctrl B is a keyboard shortcut used in various applications and operating systems to perform certain actions. It is typically used to apply bold formatting to selected text.
There are times that you need to know the sum of numeric data even though there may be errors in it. The most common of these error values are #DIV/0!, #NUM!, #N/A and #VALUE!. #DIV/0! refers to a situation where Excel is trying to divide by zero or by a cell that is blank.
To find the sum of two or more numbers, you add them together.