Excel – Using tables for data entry

Did you know how the Tables feature in Excel can enhance your spreadsheets, especially for data entry purposes?

Tables allow you to select areas in your worksheet tabs and show them like this:-

….. instead of displaying like this:-

The biggest difference in usability is that – when you are tabbing through cells in data entry – the insertion point moves from I1 to B1, instead of J1 which is the next cell on the right hand side.

Visually, a table is easier on the eyes since it is automatically formatted with alternate rows in a different colour or shade of colour (of which there is a large selection available).

To learn more about how to use tables, or any other topic, enquire now about my next online training session – or to book an individual session with Jula the PC GP.

Posted on March 21, 2022, in Uncategorized and tagged , , , , , , , , , , , , , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: