How to Insert Sheet Name into Header or Footer in Excel?
Excel allows you to specify the header and footer in a worksheet, which can be quite useful if you need to print your data in the worksheet. A lot of …
Steve Scott
Apply Comma Style Number Format in Excel
The comma style is quite commonly used when people work with financial data in Excel. It helps improve the readability of your data as it adds commas between digits (and …
How to Remove Gridlines in Excel (Shortcut + VBA)
By default, light gray colored gridlines are visible in the worksheet area in the Excel file. These gridlines are like a border around each cell that shows you the outline …
Formula Bar in Excel – Show/Hide Formula Bar!
In this Excel tutorial, I will tell you everything you need to know about the Formula bar in Excel. A lot of Excel users use the formula bar, and it …
How to Remove Space before Text in Excel
One thing that often irritates a lot of Excel users is when you have spaces before the text in a cell. While it may look harmless, these could be quite …
Why is Excel so Slow? How to Fix Slow Excel Files!
Excel is a fantastic spreadsheet tool that has evolved beautifully over the years. There are so many amazing features and functionalities that are continuously being improved and added to Excel. …
What is an Active Cell in Excel?
A lot of new Excel users often get confused with the terminologies used in Excel. One such term that you would often find in many of the Excel tutorials and …
Microsoft Excel vs. Google Sheets – Which One Is Better for You?
Microsoft Excel and Google Sheets are currently the two giants in the spreadsheet space. While there are some smaller players as well (such as Airtable, Libre Office, or Open office), …
How To Go to the Top of the Page in Excel (Shortcuts)
While Excel is amazing when it comes to analyzing a large amount of data, navigating through this data could be a challenge. For example, if you have daily sales data …
How to Paste without Formatting in Excel (Shortcuts)
When you copy and paste text from one place to another in Excel, the formatting of that text is often copied along with it. This can be a pain when …
Press Enter and Stay in the Same Cell in Excel
By default, whenever you’re in a cell in Excel and hit the Enter/Return key, the cursor would go down one cell. In most cases, this is what you want (especially …
How to Add Calculated Field to Pivot Table?
Pivot tables in Excel provide a powerful tool to group and summarize large datasets, helping you get a bird’s eye view of your data. They come equipped with a variety …