How I can Enter the Same Value into Multiple Cells Simultaneously in Microsoft Excel

16. How to Add Rows and Columns to Spreadsheets
17. How To Enter the Same Value into Multiple Cells Simultaneously in Microsoft Excel
18. How to Avoid the Unnecessary Use of Menus in Excel and Word


16. To Enter the Same Value into Multiple Cells Simultaneously in Microsoft Excel
1. Select the cells into which you want to enter the value.
2. Type the value in the active cell.
3. Press CTRL+ENTER.

17. Add Rows and Columns to Spreadsheets
To add a row or column: Select any row or column, and then press the CTRL key at the same time as the PLUS SIGN (+) key on the numeric keypad.
To delete a row or column: Select the row or column, and then press the CTRL key at the same time as the MINUS SIGN (–) key on the numeric keypad.

18. Avoid the Unnecessary Use of Menus in Excel and Word
1. In your Microsoft Office Excel and Microsoft Office Word programs, place the mouse over the status bar at the foot of the program window.
2. Right-click to reveal the Customize Status Bar menu, and then select which options you want to appear on the bar.