• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About
Home / Archives for Excel Tips

Stop PivotTable Columns Resizing

A frustration with PivotTables in Excel is the automatic resizing of column widths that occurs when a PivotTable updates. This often happens when a PivotTable is refreshed or filtered.

Let’s look at how to stop PivotTable columns resizing for specific PivotTables, and how to change the default behaviour and stop the PivotTable column widths changing in future Excel workbooks.

PivotTable Column Widths Change on Update

In this example, we have a simple PivotTable with product sales and a Slicer that enables us to filter the PivotTable by product category.

In the following image, the PivotTable is filtered to show products in the ‘Food’ category only.

PivotTable filtered by a Slicer to show specific products

When the filter is changed to show products in the ‘Cakes & Pastries’ category, the first column expands to accommodate the longer product names such as ‘Chocolate Chip Muffin’.

PivotTable column widths change on update when filtered

This is due to a PivotTable option that forces columns to autofit on update.

Watch the video: Stop PivotTable Columns Resizing

[Read more…] about Stop PivotTable Columns Resizing

LIVE Currency Exchange Rate in Excel

The rich data types make it easy to get a live currency exchange rate in Excel. You can then convert currencies with an Excel formula that updates when the exchange rate changes.

[Read more…] about LIVE Currency Exchange Rate in Excel

Non-Adjacent Columns with FILTER Function

This tutorial will return non-adjacent columns with the FILTER function. Dynamic array functions such as FILTER and SORT can only return consecutive columns natively. However, there are various methods to specify the columns to return from the array. Functions such as CHOOSECOLS, CHOOSE and INDEX are wonderful for this task.

You can download the Excel workbook to follow along

[Read more…] about Non-Adjacent Columns with FILTER Function

How to Make Table Column References Absolute

This tutorial covers how to make table column references absolute. It will cover both table column and cell references.

Download the Excel workbook to follow along.

[Read more…] about How to Make Table Column References Absolute

Create a Picture Lookup in Excel

Many Excel users are familiar with lookup functions such as VLOOKUP, INDEX and MATCH to look up information in a list. But how about performing a picture lookup in Excel to return a picture dependent upon the contents of a cell.

This requires a little extra thought as a standard VLOOKUP is not capable of returning a picture from a list.

In this blog post, we will explore how to create a picture lookup. We will look at how to return the picture of a flag dependent upon the country name that is selected from a list.

Spreadsheet Setup

[Read more…] about Create a Picture Lookup in Excel
  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Interim pages omitted …
  • Go to page 7
  • Go to Next Page »

Primary Sidebar

Recent Posts

  • Excel LOWER Function
  • How to Compare Dates in Excel
  • Stop PivotTable Columns Resizing
  • LIVE Currency Exchange Rate in Excel
  • N Function in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • Uncategorised
  • VBA

Join Our Mailing List

© Copyright 2009 Computergaga · All Rights Reserved ·