General

Excell copy action pauses for 15 second for the smallest action
Using Windows 7 and Office Standard 2007- Excell pauses after a copy or paste action regardless of size of spread sheet. ... 2 Feb 2010 17:27

How to disable page break
Hi Everyone, I want to add multiple page breaks in my file, for example on line 20, on 36, and on 42, etc, and be able to disable page break, through a marco or something, so nobody can remove them. any help will be appreciated thanks david ... 2 Feb 2010 17:27

Auto filter on blank lines
I have auto filter turned on and when I filter on something there are no longer any blank lines at the bottom of the document (it's grey). I'm not sure what I did to get rid of them but I'd like to have them back. Thanks! ... 2 Feb 2010 17:27

Changing figures
I have been told that if I highlight figures in a spreadsheet that I want to change, type in the correct figure and press enter, all the figures should change. This is not happening, is there something I am doing wrong? ... 2 Feb 2010 17:27

How do I collapse a menu in Excel
Is this question as basic as I think? Is the question asking me to minimize the Window? I have looked through all the option but do not seem to find a function to "collapse" ... 2 Feb 2010 17:27

Count cells with specific text between two dates?
I have the following formula =COUNTIF(Orders!D:D,"*Stood Down*") How do I modify it to count text between two dates which are in cells: Orders! H3 Orders! I3 ... 2 Feb 2010 17:27

Problem with Calculated item in Pivot Table
I am using Calculated Item (Not a Calculated Field) in a Pivot table to calculate variance in Budget and Actual figures. Though this is working fine and I am getting the variance calculation properly. However the page filter is not showing proper results. Once I am using page fileter to see data for a particu... 28 Jan 2010 03:10

Cell formatting doesn't display
I have Excel 2007. When I enter data in a cell, I can select it and highlight it, eg., in yellow. The highlight does not display, but it shows up on the Print preview as grey. Similar with the font color. If I select a color, eg, red, then type, the print displays in red - until I press "enter". The data d... 28 Jan 2010 01:00

Copy all Rows from Several Sheets to 1 Sheet At Once
I have several sheets in a spreadsheet file that have different employee names on them. I want to copy all of the rows that have data from each sheet onto a single sheet. Is there a macro or short cut or anything that I can use to do this with? The reason I ask is because there are like 70+ employee sheets a... 28 Jan 2010 01:00

How do i show the drop down arrow for a list in Excel
I have created an almost working data/validation/list in Excel 2003. I can see the note when I click on the cell, but it does not show me the arrow for the dropdown list. I have the "In-cell dropdown" box checked. Furthermore, it will not give me an error if something is typed incorrectly. Lastly, I can ri... 27 Jan 2010 21:43