Summary: Hi, I hide markups on my word document in 'View' menu or by clicking on 'Final'. I save the document but when I open it again, markups are shown again...
Summary: I've got a project where I've got hundreds of rows, the first several columns of which are highlighted [using conditional formatting] to light green o...
Summary: Hello, How do I hide zero values in a Pivot Table? The data behind the zero is an equal positive and negative, hence, zero! I think I need to create a...
Summary: Let's say your list of goods is in column A of Sheet1. Let's say you are entering a quantity in Column B or C of Sheet1. Right click the sheet tab for...
Summary: I just copyied a range of cells (A10:G90) in Excel...and PASTE SPECIAL > VALUES into another area (A100:G190)... There are a total of 7 columns and 80...
Summary: Every time I open word, I have these Backwards L shapes (indents) at the top and bottom of the page (In all 4 corners). I can not click on them to del...
Summary: You can modify the first column values. ex. FT1 to FT001 FT10 to FT010 so that it sorts correctly. The solution that I would use is to add a column ...
Summary: So I am thinking a Multi-criteria VLookup will do the trick. Insert a column on both sheets at Column A. The common fields are Manufacturer and Cost. ...
Summary: the reason being in my spreadhseet i hide the sheet tabs along the bottom, as it has to be designed for "dumb user" as the college calls them. it has...
Summary: I have a word document, that I am using the book fold option for (which doesn't work well) and I have a text box hidden somewhere on one of the pages....
Summary: In VB6 you would add this behind the button FormName1.Show FormName2.Hide depending on which form you want to show or hide. Access VBA should be very...
Summary: Hi friends I want to lock and hide specific columns in Excel. My problem is this If I lock the column, it does not hide And ... if I hide the Column, ...
Summary: We had considerable problems with this. It evaded our McAfee defences (now replaced) and only came up using web based scanners from Norton and Panda. ...
Summary: Hi Steve. If you open Excel without selecting a file, and your PERSONAL.XLS opens up, simply select "Window->Hide" from the menu bar, and close Excel,...
Summary: try running spellcheck when you know that you have spelling errors. In the spell check box, it will find the word. There should be an "options" butt...
Summary: I'm assuming you want to filter on an individual value, e.g. filtering on 3 would hide rows 3 and 4. I don't know of a way to use Excel's AutoFilter f...
Summary: Locking the data is surprisingly simple. As an added bonus, the data should remain protected if macros aren't enabled, assuming you pick a good passwo...
Summary: Hi, I want to include some text instructions in cells within a spreadsheet and wondered if you can set it up so those cells with the instructions prin...
Summary: this is a bit tricky! Got it to work using the DMIN function. Note this formula requires you to have headings at the top, and you'll need to hide some...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
