(Who could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she’s learned along the way.) Issue: Excel automatically makes column widths too wideI often work with pivot tables that have URLs as rows of data, and the URLs can be quite long. In the past, whenever I changed the data and refreshed the pivot table, Excel would automatically resize the column width, making the column as wide as the longest URL. This pushed all my other data to the right and out of view. To see it, I had to scroll–an extra eye-wearying, time-consuming step. Trick: How to change the default column width when refreshing a pivot table. Select Pivot Table Options.

In the Pivot Table Options dialogue box, click the Layout and Format tab, and then uncheck the box Autofit column widths on update.Now the column width doesn’t change each time the pivot is refreshed, but now you need to define how wide the column with the URLs should be. Go back to your pivot and select the column with the long URLs. Cop games for mac. Right-click, and enter a value for the column width.Now when you refresh the pivot table, the column doesn’t resize. Instead its width corresonds to the value you entered.Categories.Filed under:.

When you select part orall of the text in a cell, that selection has the same appearanceas would text selected outside a table. However, if the selection spansmore than one cell, the cells and their contents are both selected.Ifa table spans more than one frame, holding the mouse pointer overany header or footer row that is not the first header or footerrow causes a lock icon to appear, indicating that you cannot selecttext or cells in that row. To select cells in a header or footerrow, go to the beginning of the table. When adding columns, if you drag more thanone and one‑half times the width of the column being dragged, newcolumns are added that have the same width as the original column.If you drag to insert only one column, that column can have a narroweror wider width than the column from where you dragged. The samebehavior is true of rows, unless the Row Height for the row beingdragged is set to At Least.

In this case, if you drag to createonly one row, InDesign will resize the new row, if necessary, sothat it’s tall enough to contain text. Note:The first cell, last cell, previous cell, and next cell differ depending on the writing direction of the story. For horizontal writing, the first cell is in the upper left corner, the last cell is in the lower right, the previous cell is the cell to the left (the previous cell of a cell on the left edge is the rightmost cell on the row above), and the next cell is the cell to the right (the next cell of a cell on the right edge is the leftmost cell on the row below). For vertical writing, the first cell is in the upper right corner, the last cell is in the lower left, the previous cell is the cell above (the previous cell of a cell on the upper edge is the bottom cell of the row on the right), and the next cell is the cell below (the next cell of a cell on the lower edge is the top cell of the row on the left).

Converting an Excel table back to a range. If you want to convert an Excel table back to a range, you can follow these steps: Place the cursor in any cell inside the Excel table and select the Table Tools’ Design subtabs on the Ribbon. Click the Convert to Range button, as shown. When asked if you’re sure (via a message box), click the Yes button. Resize a table. Rest the pointer on the lower-right corner of the table until appears, and then drag the table boundary until the table is the size that you want. Resize rows, columns, or cells. Select the table. The contextual tabs, Table Design and Layout, appear in the ribbon.