Within a cell, text wrap around I want to line up similar to hanging indent as feature in Word, example: 7293 (era raeir aseir aif ;aeraerse rfasa...

I need to set fields to limit the number of characters entered, can it be done in Excel 2007?

Hi Everyone, I'm trying to append to a annual Excel file a daily Excel file once its made available Preferably using DOS script once my user saves the Excel...

I need to allow users to expand and collapse groups in a worksheet, that is protected - ie. I do not want people to be able to change any data. Is this...

I have a pivot table with dates, by month, along the top (in a "mmm-yy" format) and then the name of 8 companies listed down the left-hand pane. Is there any...

I get over a million lines of data on 2007, but when I take a Crystal report over, it still separates the data to 65,000 per spreadsheet - do you know how to...

Hi, Using a simple formula "SUM" the formula change himself Test this anywhere in a sheet: For this example I will use A1 to A15 In cells A16 type:...

My problem is that I have huge list of data, and I create formulas to figure averages, etc. Then, I want to sort the data and have my averages update based...

I've been working on this for hours, and I desperately need help. I'm simplifying the spreadsheet immensely, but the heart of my problem is this: In my...

I have a large cell with some info and would like to add two lines in that cell. How can I "return" so as info will be on two or more lines.

I'd like to have a master spreadsheet that will house all data I input on other worksheets. I need to create one sheet per person and enter data on each...

Does anyone know a simple way to count the number of blank cells between non-blank cells? I have a column of data that in some cases has from zero to five...

how can I convert all normal text to all CAP text? thks

I have a workbook with multiple worksheets. Each worksheet is dated with a column of dates based on a two week work period. The dates within each worksheet...

Hhow do I (left) zero fill a right aligned set of numbers without inserting each one manually?

Dear All, I need to create a check box in excel so that when I click on the box, a tick mark should come in the box. Can anyone please help. Regards, Jaipal

Is there a way I can Hide some data in Pivot table. I have 3 Rows of column that I pivot but I want only one row to show without anyone having access to the...

FB1 FB2 FB3 00 01 02 03 04 05 FB4 0 C1 1 C2 2 C3 3 C4 4 PO 5 PO1

Does anyone have any suggestions on how to set the formula? I would like to convert any number in cell A1 into 3-digit number under 360. If the given number...

Hi, Spreadsheet 1 has column B with Network number, C with Name, D with Description. In spreadsheet 2 , in column A i will put Network number and I want the...