I have a text spreadsheet of 5,000 names and addresses. Column B needs to restricted to only 16 characters in that column. How do I send the records to...

How can I split the worksheet - columns A - C in left pane and the rest in the right pane - and freeze the left pane while allowing scrolling in the right...

I need help.... The following statement is being used in a do loop. ActiveCell.FormulaR1C1 = "=IF(" & TagNmeMe & "!RC="""",""""," & TagNmeMe & "!RC)" What I...

Hi Can anyone please tell me how I change the colour that track changes displays in in Excel 2003? Mine is currently displaying changes in Navy which is...

I don't know whay I can't inculde more than one formula in one...

I saved a backup of a workbook with four worksheets (the fourth being a summary of the other three). I was correcting references which were incorrect by...

The horizontal lines on every new worksheet have disappeared in one very large worksheet. Makes it much easier to read if the items are separated by lines....

Is there a VBA command to move the cursor up one row ? Thanks.

How can I view a spreadsheet that includes the tool bar on the tob and the tabs for multiple sheets on the bottom?

Can anyone tell me the formula to add hours 9/weekday & 4.5/sat & all hours worked sunday. 7 columns starting wed finishing Tues. Cheers Bridget

After defining a new Name ("_year") in my worksheet, I find that my makro code (Private Sub cmdNewEntry744_Click() With NewEntries ..Show End With End...

I have a spreadsheet that makes some calculation in a column, based on multiplying numbers entered in 2 other columns. However, for some of the rows, there...

I have a large file that somehow has pictures in it that are not visible (they seem to be sized down to 0) but are causeing the file to be too big. When I...

I don't know why can't I make more than one If formula in one Cell. Like...

Hi gurus. I would like to have the cells in my spreadsheet do something automatically, if that is possible: I would like there to be some space between the...

0 Valid 0 Expired Enrolled Valid 0 Expired Enrolled Expired If the Cell in Column (1) is the Word (Enrolled), the Result will be enrolled. If not the Word...

I have a project that requires me to copy mutiple worksheets to one hub worksheet. Is there a way to make the worksheet name a variable? This is what i have...

I am copying an excel spreadsheet to Word. I get a bordered dotted blue line area in a merged cell for comments and can't delete the blue lined araea. I also...

When I choose a cell to highlight or to begin typing in, 2 or 3 cells below the selected cell automatically are highlighted. This does not happen on every...

I seem unable to select a single cell, or a single row--click on one in the normal manner, and the two below also highlight, then delete or whatever command...