This tutorial demonstrates how to hide column and row headings in Excel. Hide Column and Row Headings In Excel, you can hide the numbers at the left of each row and the letters at the top of each column. These numbers and letters are column and row headings. To achieve this, in the… Continue Reading
This tutorial will demonstrate how to add a macro button in Excel VBA. Once we have created macros in Excel, it is sometimes useful to create a button in the Excel worksheet to run the macro. Also, as we use VBA to create UserForms in Excel, we need to be able to create buttons on… Continue Reading
This tutorial demonstrates how to use split screen in Excel. Split Screen The split screen option in Excel is useful when you have a large set of data you want to scroll through horizontally or vertically. In that case, Excel allows you to split the screen into four parts (panes) and scroll each… Continue Reading
This tutorial demonstrates how to show the formula bar in Excel and Google Sheets. Show Formula Bar Shortcut PC Shortcut:Ctrl+Shift+U Mac Shortcut:^+⇧+U See All Excel Shortcuts Show the Formula Bar The picture above shows the formula bar in Excel. It’s possible to show and hide this part of the display, depending on your needs. Use… Continue Reading
This tutorial will explain the VBA Out of Memory Error. The VBA Out of Memory error occurs when Excel has used all the resources of your machine while running a macro and literally runs out of memory to carry on calculating or running code. This could occur when you have a lot of applications running… Continue Reading
This tutorial will demonstrate how to add a Secondary Axis in Excel and Google Sheets. How to Add Secondary Axis (X & Y) in Excel There are a variety of ways that a secondary axis can come in handy. This can be helpful when you’re plotting value ranges in a number of series that vary… Continue Reading
In this tutorial, you will learn how to hide zeros in Excel and Google Sheets. There are several ways to hide zero values in Excel: Hide zeros in the whole workbook using Excel Options. Hide zeros using a custom number format. Hide zeros with conditional formatting. Hide Zeros – Excel Options In the… Continue Reading
This article will show you how to use the Create Object method in VBA. VBA is an Object Orientated Language – it uses procedures to control and create Objects. Create Object We can use the Create Object method to create an Object in a Microsoft Office application. For example, if we are writing VBA code… Continue Reading
This tutorial demonstrates how to track changes in Excel and Google Sheets. Track Changes in Excel has been replaced with a feature called co-authoring, which is a replacement for shared workbooks. However, you can still use the old Track Changes and shared workbooks feature in Excel 365; just unhide the command to do so. With… Continue Reading
This tutorial shows how to insert and remove headers and footers in Excel and Google Sheets. Insert a Header in Excel In Excel, headers and footers appear at the top and bottom of each page you print. To insert a header in Excel, follow these steps: First click on Insert tab… Continue Reading