Q. I usually like Excel PivotTables, but because they don’t allow me to do certain things, such as delete cells or insert new columns or rows, I’m wondering if there is a reasonable alternative? A.

Q: How do I add a percentage-of-total column in a PivotTable in Excel 2010? Your PivotTable will now display the same two columns of data both numerically and as a percentage of total, as pictured ...

Microsoft Excel spreadsheets frequently use similar formulas along columns. For example, you might need to keep a running total or tabulate a list of product inventories. Repetitively typing each ...

Data validation in Microsoft Excel is a great way to limit what can be entered into a cell. However, creating rules using a formula allows you to enforce even more precise parameters—and there are ...

Up-to-date information can be critical; these 4 tips will add flexibility and increase efficiency when refreshing pivot tables. Image: Getty Images/iStockphoto PivotTable objects are only as good as ...

How to display the top n records in an Excel PivotTable using built-in options Your email has been sent In a previous TechRepublic article, How to highlight the top n values in a Microsoft Excel sheet ...