This tutorial demonstrates how to autofill the alphabet and other custom lists in Excel. Excel is able to recognize patterns and autofill a list based on a single entry. This is often used for days, months, numbers, etc. You can also create a custom list with your own data, and Excel will use… Continue Reading
This tutorial will demonstrate how to use shortcuts when working with PivotTables. PivotTable Shortcuts What is a PivotTable? A PivotTable is a great tool that uses a table to summarize and analyze data. This can better understand the data to see trends and comparisons. The PivotTable below shows the units and sales from 2016 to… Continue Reading
Fill Down and Fill Right Fill Down Fill Down is helpful when you want to drag a formula down to the end of the column. Highlight the rows to copy the formula down. PC Shortcut:Ctrl+D Mac Shortcut:^+D Remember This Shortcut: D for Down Fill Right Fill Right is helpful when you want to drag… Continue Reading
This tutorial demonstrates how to remove dashed print area lines in Excel. Remove Dashed Print Area Lines Once you’ve used Page Break Preview in Excel (View > Page Break Preview) to view and set page breaks, you’ll see dashed lines separating pages for printing, even when you go back to the normal view. Say… Continue Reading
This tutorial demonstrates how to create a bulleted list in Excel and Google Sheets. There are several ways that bulleted lists can be created in Excel. This tutorial introduces a few methods. Create a Bulleted List With a Shortcut Key Select the cell you wish to start creating your bulleted list in, and then while… Continue Reading
This tutorial demonstrates how to create and automatic currency converter in Excel and Google Sheets. Excel is a powerful tool for calculations, often involving international currencies. Excel does not have a built-in currency conversion tool, but with a link to an external XML database, you can build your own conversion tool into Excel using Power… Continue Reading
This tutorial demonstrates how to show and hide gridlines in Excel and Google Sheets. Gridlines are the horizontal and vertical gray lines in your worksheet that allow you to see the separation of cells in Excel. They make it easy to navigate through cells and read the data contained within each cell. Hide… Continue Reading
This tutorial demonstrates how to insert a text box in Excel and Google Sheets. Insert a Text Box In the Ribbon, go to Insert > Text > Text Box. Click in the Excel worksheet where the text box needs to go, and drag down and to the right with the mouse to size… Continue Reading
AutoMacro Write Better Code, Faster & Easier! See Pricing Read all reviews Documentation Read Docs Start Here Read Docs Code Library Read Docs Read Docs VBA Code Generators Read Docs Read Docs Read Docs Read Docs Read Docs Misc. Read Docs … Continue Reading
This tutorial demonstrates how to make a shared spreadsheet for multiple users in Excel and Google Sheets. Depending on the version of Excel, users can either share a workbook, or allow co-authoring. In Office 365, Microsoft encourages users to use OneDrive and allow co-authoring of workbooks on the web. For this reason in… Continue Reading