expand

Hi, I have created a pivot table that is connected to an input sheet with data. The input sheet retrieves data automatically from a external source through an add-in to Excel. When updating data the fields expands, but only for the items which have been changed. I want the table to be updated...

I have a large spreadsheet with three columns of info. In Col A is the group name, Col B is the sub-group name, and Col C is a list of the items. Each group name in Col A has a very small icon on the left side, showing a + or -. By clicking on the +, the data in Column B opens up. Each item...

Hi all, I have a file with ten worksheets which have data groups in the same position on each sheet. I'd like to expand and collapse them on all sheets by using grouped sheets but it seems this isn't possible when clicking the + or - box, or clicking on the 1, 2, 3 etc boxes in the top left...

how to expand print area in excel 2007 example M colums.the file is below: http://www.mediafire.com/?vz4768tkgd31ubl

Hi, How can I set merged cells (with wrap text option activated) to automatically expand when current height is exceeded ? I've unsuccessfully tried many ways. Can somebody help ? :confused:

Hello, I have a worksheet, and all the cells contain data. When I want to sort a colum alphabetically, normally excel asks if I want to expand the selection (and I want it to be expanded). But in this particular worksheet it doesn't give me the option. I just sorts the first colum, and the...

Hi, I'm hoping there is an easy fix for this. I have a sheet which has a number of subtotal rows (the number of subtotal rows may vary depending on the data). I'd like to increase the row height for only the subtotal rows (not the rows of data included in the subtotal (above the subtotal...

Folks: How do you write a macro to expand all pivot table fields in Excel 2010. Hit + buttons on all like when recorded for just this one: ActiveSheet.PivotTables("PivotTable2").PivotFields( _ "Cost Center").PivotItems("77194").ShowDetail = True Thanks, Rowland

Is there any non-macro way to ensure that the print area of a worksheet expands as more rows are added to a table? I can add a macro to do it but the file is shared by many and is large - people may not all know to enable macros and an on change macro might slow things up a bit. Any ideas or...

Hello Everybody, The auto expand tables' new row format does not match the rest of the table. Using VBA to autoexpand a table by finding the row below the table and making an entry. There is headers and a total row. This happens also when manually turning off the total row, and then typing...

Hey all. I've used this code in Access 2002/3 for some time and it has always worked just fine. It basically uses a timer to see how fast your computer is running through the code to ensure that it takes all computers the same amount of time to expand or animate the form's opening. However...

Hello... anyone feeling on the ball on Monday morning? I have a pivot table (Excel 2007) with 3 groups before a count field: Country / Drink / Size / Count of names The issue is when I expand an item in the second group (say Lager) for a country (say UK) that item expands in all country...

After working with VS 2008 and other text/code editors I've found I really enjoy the auto-outline feature (i.e. expand/collapse code). Does such an add-on exist for VB6 IDE?

I write proposals for a services company. My budgets can have 10 services, with 80 rows per service. Often, not all services are needed. I would like to create a way to only expand only the service categories needed. I would like a cell to trigger this to open (currently each service area is...

Hi I really need some help either writing a macro or finding another way to have my database automatically fill data in a row when new values are added. I am working with excel 2007, I have a database where I add information pulled offline. I copy/paste the values into a new row under the...

Guys I have a company sheet that is being developed for use by others. I need to lock the sheet in terms of formula editing etc but need to allow users to add data into the list and for the list to automatically expand when the user reaches the end of the defined list. The list function does...