Very good article about excel
Using Ctrl+Enter to place information into multiple cell simultaneously!
If you need to enter the same data into multiple cells, Excel offers a fabulous shortcut.
- Select all the cells that you need to change.
- Enter the value, text, or formula.
- Press Ctrl+Enter.
- The same information is inserted into each in the selection.
Using a form for data entry!
When you have a list of information in a table, the column names do more than describe what needs to be typed in that column but can be used in a form. If the table has many columns, it may become an inconvenience to scroll back and forth. One way is to use Freeze Pane to keep the main column(s) and row(s) from not moving. I recommend using the Form command which will become a data entry where it will display the column headings as fields for input.
- Place in the Quick Access…
View original post 316 more words