Subscribe for access to this FREE e-learning mini-course!

Your First Name:

Your Surname:

Your Email Address:


Small logo
Hamburger menu
bookings:   0333 6000 111
service:       0333 6000 555
eBook Download

If you would like to receive our FREE eBook, please enter your email address below and click Send eBook.

Send eBook

Video Tutorials - Formatting in Excel Resources
Video Tutorials - Formatting in Excel Resources

Video Tutorials - Formatting in Excel - Resources

Content produced for your benefit: use, modify and share as you wish

Dates Need to Be Formatted!

When using spreadsheets created by different people, you may notice they use different formats for data in the cells. Differing date formats tend to be the most common and correcting these so they are uniform, can be a real pain, particularly if people are...
The Need for Formatting... or Re-formatting

When you are working with dates, currency and numbers in Excel, it is important to present data in an attractive and uniform way. And we all have our own preferences.

But when you work on a spreadsheet that has been created by someone els...
Sometimes multiple format changes are required in Excel on various locations and sheets within a Workbook, this can be time consuming and ineffective.  Excel can provide a more efficient way of doing this for you.

Format Painter is a very powerful and efficient method of copying for...
Excel will often wrap text onto multiple lines within a cell when a column is too narrow. This is fine in most situations but can be annoying if you are trying to format a spreadsheet and ensure that your data fits how you want it to in the columns.

Let’s look at an example below:

When working with Excel it could be useful to select data from a drop down list of options and have that selection further filter information available from another drop down list.

E.g. you could select the application name such as Excel and a second drop down list would only show th...
Formatting data is important in Excel as it allows you to apply emphasis to information as well as clearly mark any headings and totals.

The useful ones for your data are things like Control + B for Bold, Control + I for italic. Control + U for Underline. Alignment shortcuts don’t ...
It can be useful to turn Gridlines off and on to create better looking spreadsheets and forms.

Click on the View Ribbon and turn off the Gridlines by unchecking the gridlines box. You can apply your own formats to the data as needed and press Save to keep your changes.

It may help ...

Stay in touch

Stay In Touch!


Contact Details

Activia Training

Locations Address: Head Office, Regus House,
268 Bath Road
Slough, Berkshire SL1 4DX

Phone Sales:           0333 6000 111

Service:       0333 6000 555

Nationwide coverage
Click to view all locations

Back to top
    Expert Insights
About Us
    Useful Information
    CPD Accredited Training
    ILM Accredited Courses
    Special Offers
    Training Vouchers
    Career Opportunities
    SUBSCRIBE To Our Newsletter
Free Tools
    Personal Development Tests
    Speedy Quote
    Bespoke Course Creator
    Test Your Skills
    Free Online Revision
    Activia Training Scholarships
    NEW: Activia GateWay
Contact Us
    Callback Request
    More Information
    Schedule your own class
    Free eDirectory
Time Management
Communication Skills
Prices for Online Courses
Online Training FAQ
VIDEO: How to Use It
Time Management
Communication Skills
Building Relationships
Free Microsoft Office Course
Microsoft Access
Microsoft Excel
Microsoft Outlook
Microsoft Powerpoint
Microsoft Project
Microsoft Word
Microsoft Access
Microsoft Excel
Microsoft Office (incl. 365)
Microsoft Outlook
Microsoft Powerpoint
Microsoft Project
Microsoft Publisher
Microsoft Visio
Microsoft Word
Crystal Reports
Management Skills
Performance Management
Supervision & Teams
HR and Coaching
Accounts and Finance
Project Management Essentials
PRINCE2® Project Management
HR and Recruitment
Training & Coaching
Presentation Skills
Sales Management
Negotiation Skills
Business Writing Skills
Minute Taking Made Easy
Professional Telephone Skills
Touch Typing
Customer Service
Receptionist Skills
Time Management
Communication Skills
Building Relationships
London Victoria (SW1)
Tower Bridge (E1)
Bristol (BS1)
Milton Keynes (MK9) NEW
Reading (RG1)
Slough (SL1)
Birmingham (B4)
Nottingham (NG1)
Manchester (M1)
Leeds (LS1)
Site Cookies
We have placed cookies on your device to help make this website better.

You can change your cookie settings in your browser. Otherwise, we’ll assume you’re OK to continue.

I'm fine with this