Forum Discussion
Office_Manager_Brad
Mar 11, 2024Copper Contributor
How to set tab order of cells in Excel
I've been searching for a method to set the tab order in my sheet. In this situation, I'm entering the time for hourly employees (skipping over the salaried employees), so it would go B4 to D4 to F4...
djclements
Mar 12, 2024Bronze Contributor
Office_Manager_Brad What is the reason for not grouping your hourly and salaried employees together? It seems like the easiest solution here is to have the hourly employees in columns B thru F, followed by the salaried employees in columns G and H.
Also, what is the significance of having multiple blocks of data for Billable, Non-Billable, Timesheet and Office Misc? Does each block represent a single day? If so, do you have a "Date" column somewhere in your actual dataset that identifies the day?
It's possible to improve data entry efficiency simply by rearranging your data in a manner that accommodates the order in which you read/input the data from the source document(s). Just a thought...