Search Results for: scroll

How to Change Table Style in Excel & Google Sheets

This tutorial demonstrates how to change table styles in Excel and Google Sheets.     Change Excel Table Style If your data is formatted as a table in Excel, you can access the Table Design tab on the Ribbon. Select the table, and then in the Ribbon, go to Table Design > Table Styles. Scroll to… Continue Reading

Installation and Troubleshooting

Installation To install the software follow these steps: 1. Close All Microsoft Office Programs (Excel, PowerPoint, Word, Outlook, etc.) 2. Click the AutoMacro downloaded file in your browser (see image below) or navigate to your download folder and double-click the MSI file. (Click here to download) You may see a warning message. This is a… Continue Reading

What to Do When Excel Keeps Crashing / Freezing

This tutorial shows what to do when Excel keeps crashing or freezing.     Sometimes, Excel might hang or freeze when responding to an error – or crash completely. This can happen for various reasons, and the solution may be as simple as rebooting your PC or updating your antivirus software. However, if neither of… Continue Reading

How to Fix When Loading Excel Solver Not Working

This tutorial demonstrates how to fix the error when Solver is not loading in Excel.     Solver is an add-in that is provided with Excel and is used to perform “what-if” analysis by providing alternative answers to a formula in a cell based on values you may pass to the formula from other cells… Continue Reading

Data Entry Form w/ Drop-Down List in Excel & Google Sheets

This tutorial demonstrates how to create a data entry form with a drop-down list in Excel and Google Sheets.     The automatic form feature of Excel is often overlooked as you cannot find the command to create a form on any of the Ribbon tabs available by default. If data entry is part of… Continue Reading

How to Create a Pivot Table in Excel & Google Sheets

In this ArticleCreate a Pivot TableWork With Pivot TablesRefresh a Pivot TableDelete a Pivot TableFilter and Sort in a Pivot TableGroup Pivot Field ItemsCreate a Pivot ChartPivot Tables in Google SheetsMore Pivot Table Tutorials This tutorial demonstrates how to create a pivot table in Excel and Google Sheets, and how to work with pivot tables.… Continue Reading

Freeze / Unfreeze Panes – Excel & Google Sheets **Updated 2023**

In this ArticleFreeze PanesSplit PanesFreeze Top RowFreeze First ColumnUnfreeze PanesFreeze / Unfreeze Panes in Google Sheets This tutorial demonstrates how to freeze and unfreeze panes in Excel and Google Sheets.   If you have a large worksheet, it is sometimes useful to always be able to see a few specific columns on the left side… Continue Reading

AutoComplete With Data Validation in Excel & Google Sheets

This tutorial demonstrates how to autocomplete with a data validation drop-down list in Excel and Google Sheets.     Data Validation and AutoComplete Creating a drop-down list in Excel using data validation is useful in restricting the data input allowed. However, if the drop-down list has many items, scrolling down the list looking for the… Continue Reading

VBA Dictionary Objects

This article will explain and demonstrate the use of the VBA Dictionary Object. VBA allows a user to create class modules where the user can create collection objects.  A VBA dictionary can be compared to a collection object or array in that it stores information in memory while the VBA code is running and allows… Continue Reading

How to Fix Excel “Cannot Paste the Data” Error

This tutorial demonstrates how to fix the “can’t paste this here” error in Excel.     There are several possible reasons Excel can’t paste your data. Here are four ways to try and fix it: get rid of merged cells, use the newest Excel extensions, use Paste Special, or change DDE settings. Unmerge Cells If… Continue Reading