Select the cells you want to merge. Highlight them with your mouse in one cell, holding Shift, then using the arrows to select...

New worksheet, type the entries you want to appear in your drop-down list. Select the cell in the worksheet where you want the drop-down...

Freeze Panes has been around for a while, and you’ve most likely seen or worked with a spreadsheet with a frozen top row or columns...

Select the range of cells that has duplicate values you want to remove. Subtotals from your data before trying to remove duplicates....

Set up QuickBooks Online for 1099s. Hover over the Expenses tab in the left-hand menu, then click on Vendors....

Protecting Excel files is a very simple task. There are multiple ways in which you can you do this. Open the Excel file you want to protect...

The pivot table is one of Microsoft Excel's most powerful and intimidating functions. Powerful because it can help you summarize...

Open QuickBooks Desktop (QBDT). AT the login window, click the I forgot my password link. Fill in the information ...