Skip to content
Julia the PC GP

Julia the PC GP

Individual support and training for your home and small business computing needs

  • Welcome
  • Sales
    • Buy the IT items you need from Julia the PC GP
  • Support
    • Desktop Computers
    • Laptops
    • Mobile phones
    • Safe browsing directory
  • Tips & Advice
    • Desktop computing tips
    • Handy Windows keyboard shortcuts
    • Mobile computing tips
    • iPad tips
    • iPhone tips
    • General Tech Tips
    • Tips – by category
    • Jargon Buster
  • Tuition
    • Tech Confidence sessions with Julia
      • Microsoft Office tuition – Sample topics
        • Accessibility
          • Visual Impairment
          • Cognitive or learning disability
        • Hearing impairment
    • Resources
      • Training videos
  • About Julia
    • Julia Info
    • Community
    • Testimonials
    • Secretarial/Administrative Support service
  • Enquire now
  • Toggle search form
Picture of table formatting

Excel – Using tables for data entry

Posted on 5 November 20237 February 2025 By JuliaEEvans No Comments on 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).

Appreciate this post? Like it and share it using the buttons below

Loading…

Microsoft, MS Office Tags:cells, data, excel, tables

Post navigation

Previous Post: Unfreezing your Windows PC
Next Post: Office Online for FREE!

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Thank you for visiting - may I have your feedback? Julia

  • Using your Android apps
  • Adobe Acrobat Reader – Classic View
  • Online forms
  • Advice for Parents on Internet Access
  • Buying software or IT services online
  • Accessibility
  • Accessories
  • Apple
  • Children
  • Email
  • Gmail
  • Internet
  • iPad
  • iPhone
  • Microsoft
  • Mobile devices
  • MS Office
  • Online
  • Security
  • Shortcut keys
  • Smartphones
  • Uncategorized
  • Windows 10
  • Windows 11
  • Windows 8
  • Zoom
May 2025
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  
« Feb    

Archives

  • February 2025
  • December 2024
  • November 2024
  • October 2024
  • July 2024
  • April 2024
  • March 2024
  • February 2024
  • December 2023
  • November 2023
  • October 2023
  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022

Copyright © October 2024 Julia the PC GP.

Powered by PressBook WordPress theme

%d