In some large Excel workbooks a dependent cell may refer to a precedent cell on another worksheet or many rows or columns away. The Excel Watch Window lets you see the dependent cell adjust as you make changes to the

One of the most common questions we get about Excel is how to print spreadsheets. Spreadsheet content tends to be irregularly shaped and doesn’t fit on an 8.5 x 11 sheet well. Excel has a few tools for controlling how

Microsoft opened their Office suite to 3rd party development in 2013. In the same way that the functionality of a smart phone can be extended with an app, Microsoft Office apps can be downloaded to add new features. Microsoft itself

A secondary Y-Axis in an Excel chart helps different types of data fit well together on the same chart.For example, a data set that includes the number of truckloads sold and the dollar value sold will not show up well

Excel PowerPivot is a tool for managing and visualizing complex data within Excel. It has elements of a database system like Access but also offers Excel features like Pivot Table.PowerPivot is free with Office 2013, but you may need to

Use the name box to enter information into your spreadsheet instead of clicking on each cell. This will prevent you from entering information into the wrong cell by mistake.Usually when you click on a cell and start typing, Excel deletes

Recording a macro with a complex sort is actually very simple.Start with your data unsorted and unselected. Then under the View tab, click on the down arrow just below the Macros Icon and choose Record Macro.Type a Macro name that

Excel has tools for complex, or multilayered sorts that involve several columns or headers. There are 2 ways to create a complex sort in Excel. Method 1 – The Sort button Select the all of the data in the table

Sometimes when pasting data into Excel, a column will widen to the point that it can’t really be used. A long URL, for example, might stretch off the page.Normally, you would grab the border between the column labels to resize