Hi All, I am hoping someone will be able to help me out here; I currently have a spreadsheet containing stock that has been sold over the last year. Column...

I have a long skinny Excel worksheet. I'd like to print it to one page, however this crunches it down to one column. Is there any way to force Excel to make...

From Microsoft training on Loops. Copied the following Do While Loop: Sub CountRows() x=ActiveCell.Rpw y=ActiveCell.Column z=0 Do While Cells(x,y).Value ...

I have a simple averaging formula in an excel spreadsheet that is now providing nothing but a zero as a result of the formula. I have ensured that the cell...

Column A Column B Column C Column F Column G Column H DATE PRODUCT QTY DATE PRODUCT QTY Oct...

is there a way to have excel figure out cetain dates for example the last saturday of every month for the next year?

Hi All.... I'm using a formula (=SUM(E96+C97)-D97) to calculate some line items. How can I edit this so that the cells below it are blank until a figure is...

I have an Excel Worksheet that is formatted with borders and shading. When I type into a cell, or paste into a cell, the formatting disappears, and seems to...

I have a list of contacts with data. One of the columns is for "date". However, ONe of the lists I have has the date formatted as "general" and when I try to...

Sporadically when trying to save an EXCEL file to the A: drive it locks up the computer. Does not happen from any other Office app. Using Windows 2000 Pro...

Column A has a random sorted list of text values, column D also consists of same values but not in the way sorted as column A. What I want is to sort Column D...

When I use filters on pivot tables that others create, I can select multiple values on which to filter. There is a little white box next to each item that I...

It is difficult to set a default Windows Explorer view. When I open WE I always want Explorer Bar to "Folders" and View to Details. When I click on a folder...

I have a CSV file with the following information: "Co","Profile","Profile Name" "003","MAR4","MARK ROGERS - District or Corp Accountant" "004","MAR4","MARK...

Hello, this is my range: Set myRng = .Range("E3", .Cells(.Rows.Count, "E").End(xlUp)) It is possible to set my range to jump 2 rows. Example. E3, E5,E7,E9...

Is there a way to make the highlight on a row number stretch across the entire row? Thanks

I would like the lowest value of columns d ,e, & f to be bold. Some of the cells have text. Thank you, Dan

I saw a forum response a while back that will allow programming the cursor to move to certain cells as the user enters data. I cannot remember how that was...

I've reviewed all of the questions and responses, but, didn't find anything similar to what I needed. My table has one column which adds values, positive and...

Mary, Here is what I use. Feel free to use it. Note it effects ALL sheets in the workbook including charts. The comments include installation instructions....