Excel Pro Tips
How to View Excel Worksheets Side-by-Side Vertically
Learn how to view Excel worksheets side by side vertically using new windows, View Side by Side, sync scrolling, and fixes for common issues.
Read article
Excel Pro Tips
555 articles
Excel Pro Tips
How to Find Last Column with Data in Excel (4 Useful Methods)
Learn how to find the last column with data in Excel using address references, character codes, formulas, or automatic VBA methods.
Read article
Excel Pro Tips
How to Count Characters Including Spaces in Excel
Learn how to count characters including spaces in Excel using LEN, LEN with TRIM, and SUM with LEN for single cells and ranges.
Read article
Excel Pro Tips
How to Convert Hours to Minutes in Excel (4 Suitable Ways)
Convert hours to minutes in Excel using formulas, the CONVERT function, or cell formatting options from context and main menus.
Read article
Excel Pro Tips
How to Use IF Statement in Excel Conditional Formatting
Learn how to use the IF statement in Excel conditional formatting with helper columns, direct formulas, and VBA to highlight results.
Read article
Excel Pro Tips
Custom Format to Add Text after Number in Excel
Learn how to add text after numbers in Excel using custom formats, conditional suffixes, scaling, symbols, and VBA alternatives.
Read article
Excel Pro Tips
How to Use Conditional Formatting Based on VLOOKUP in Excel
Learn how to use conditional formatting with VLOOKUP in Excel to highlight values, compare targets, and explore XLOOKUP, MATCH and VBA.
Read article
Excel Pro Tips
How to Make Yes Green and No Red in Excel (5 Examples)
Make Yes green and No red in Excel using conditional formatting, filters, VBA Editor, or Office Scripts for highlights easily.
Read article
Excel Pro Tips
How to Remove Conditional Formatting in Excel
Learn how to remove conditional formatting in Excel using Clear Rules, Quick Analysis, Paste Special, Clear Format, or VBA automation.
Read article
Excel Pro Tips
How to Insert a Watermark in Excel (3 Easy Methods)
Learn how to insert a watermark in Excel by adding an image via Header & Footer, using WordArt text, or inserting a background image.
Read article
Excel Pro Tips
How to Create a Custom Footer in Excel (3 Suitable Ways)
Learn how to create a custom footer in Excel by using Page Layout view, customizing via Page Setup, or adding one with a VBA macro.
Read article
Excel Pro Tips
How to Insert Logo in Excel Header (with Easy Steps)
Add a logo to an Excel header by opening Header & Footer view, selecting a section, inserting the image, confirming it, adjusting the size.
Read article