Excel Tips & Tricks

My Excel Tips & Tricks are collated here for you by function, and also by keyword, it’s pretty straightforward, and if you still need some help- use the Search Box at the top right of screen.

Don’t forget YOU can comment on any of the posts or email me directly at barbara(AT) howtoexcelatexcel(DOT)com and I’ll answer your questions….. Join in the discussion and contribute!

Change The Colour Or Worksheet Tabs

Save A Preview of an Excel Workbook

Remove carriage returns in a CSV file

Split Excel data using Text To Data Function

Create A timestamp in your excel files

Text wrapping in Excel

Format cells that contain text only in Excel

Change The Shape Of Excel’s Comments Box

Highlight changes made to your workbooks

Protect a Excel workbook

Conditional formatting- the basics

Centre a title across a worksheet

Transpose data from rows to columns