Excel Formatting Guides
Formatting-focused tutorials for improving spreadsheet clarity, navigation, and day-to-day usability.
15 articles
Pivot Charts: An All-Encompassing Guide
Pivot charts are often the best way to spot trends or errors, and a better way to present your data. Here's everything you need to know to make them in Exel...
How to Add a Row in Excel: Step by Step Process
Microsoft Excel is a great tool to use for work, school and even for personal data purposes. In case you're wondering, here's how to add a row in excel....
How to Hide Columns in Excel
As great as columns are in Excel you don’t always need to see every single one. Let’s take a look at how to hide columns in Excel, and unhide them too....
How to Freeze A Row in Excel: A Practical Guide
Learn to how to freeze a row in excel (or even more than 2 rows) using this practical how-to guide. Excel has an available feature allowing users the ability to freeze a row....
How to Freeze Cells in Excel So Rows and Columns Stay Visible
Do you often work with long rows & columns of data? Minimize the time you spend scrolling up, down, and sideways by learning how to freeze cells in Excel!...
How to Alphabetize in Excel: Fast & Simple
Using Excel we can properly organize data for our businesses or personal finances. Learn how to alphabetize in excel so it is easy to read and refer back to whenever necessary....
Pivot Tables (PV Table): Everything You Need to Know
When working with Excel spreadsheets, it can be difficult to extract the information you need from large sets of data. Pivot Tables (pv table) offer a great way to quickly condense and analyze, and present your data, all...
Learn How to Unhide Cells in Excel Using Keyboard Shortcuts or the Home Menu
Learn how to unhide columns in Excel using keyboard shortcuts or the Home Menu methods. While Excel does not allow you to Hide and Unhide individual cells using the Hide/Unhide command, here’s a trick showing how to hide...
The Drop Down Basics: How to Make a Drop Down List in Excel
This article shows you how to make a drop down list in excel. It provides two ways for you to quickly and easily make dropdown lists in an Excel spreadsheet. You can follow the instructions to create a new dropdown list...
How to Add Cells in Excel to Sum Up Totals Automatically
Excel's great for displaying data and even better at crunching numbers. Here's how to add cells in Excel to sum up totals automatically... Even when you change the numbers....
How to Merge Cells in Excel (and Split Them) for Better Layouts
Do you want to make your Excel spreadsheets more presentable? Here are a few useful tips on how to merge cells in Excel that would surely make your work look tidier....
How to Use the SUMIF and SUMIFS Functions in Excel
Lessen the time it takes to compute complex equations with the SUMIF and SUMIFS functions on MS Excel. This update may be just what you've been waiting for. Follow this in-depth, easy-to-follow guide to get started...
International Short Date Formatting for the TEXT Function
A quick method to automatically give the TEXT function a short date format that matches the computers region settings by using some VBA code in Excel....
Let Excel Convert Hours Between Two Dates and Times
Let Excel Convert Hours Between Two Dates and Times by subtracting one time/date from another the use the custom time format [h]:mm or [h]:mm:ss....
Indent Left and Right to Align Cell Contents
Both Left and Right Indenting is useful to align cell contents in Excel to make data more readable. Left Indent for text and Right Indent for numbers....
About Excel Semi Pro
Since 2010, we have been helping people improve their Excel skills. Here, you will find beginner and intermediate tips on navigating spreadsheets to achieve results.
Read more about us