When importing text files into an Excel worksheet I previously went to "data" "import external data" "import text file" With Excel 2002 my choices lead...

I want to sort contract numbers in Excel the same way we do in our filing system at work. Our contracts contain both numbers and letters, but excel won't let...

MWSoccer18, Different shortcut combinations? Or In a module put this sub. Private Sub Chooser() If Sheets("Sheet1") = ActiveSheet Then

Hello, How can group adjacent columns independently? If I group them one at a time they get grouped as one block. Please advise.

Every Time i want to Enter some Text in to Excel it is automatically formatted as Scientific Text .. IE: I enter in 5E1 amd Excel Automatically formats the...

I am trying to process a large amount of data that has the format dd/mm/yyyy hh:mm:ss and needs to be converted into yyyy/mm/dd hh:mm:ss. I have...

I have written an App which runs fine on a Windows PC (Win98 or XP) with 128 Mb or RAM It immediately runs out of memory when run on a Mac of similar spec...

I have a workbook where numbers are entered as whole numbers (includes cents but no decimal point) on one worksheet. These numbers are pulled into another...

Does anyone know how I can paste the find all into a new column in the same corasponding row number? I did a copy from the "Findfind all" list by...

Hi! I have an excel file that needs iteration. However, it appears the setting saved with the file is sort of global: If it is opened with a fresh instance of...

I frequently have to read .csv files into MS excel. These are textual files, containing text fields, floating point numbers, integers and times. The first item...

Hi got a problem with excel. everytime I open a file the cells are formated in a date format and I have to reformat them. Any suggestions to solve...

I get the following message every so often when running Excel 2003 under Win XP: "Can't create backup file. Save without backup?" I respond: "OK" "Your...

Hi, I have a workbook that has a worksheet with default printing copies of 3. Even when I go to page setup and change the number of copies to print to 1 it...

Hi group, I have a table set up where have added comments to certain of these cells. The comments are not hidden as I have them always shown. I like to copy...

Is there a way to delete all the odd or even rows in an Excel file? I'm dealing with a list of around 30,000 people and I need to delete all the odd rows. Is...

Is there any way to have getpivotdata retrieve more than one set of data, other than doing it like below? =GETPIVOTDATA('Roll-up Pivot'!$F$2,"hours enrg E...

Hi, Im using Excel 2002. In paste special "Column Widths" option is there but "Row Widths" option is not there. Is there any reason why it is so. Regards,

Hello All - I have a need to print an excel database file. The file is 3 columns wide and about 1500 rows. How can I print it to paper where it will print two...

Can anyone help me out with this? I want a worksheet to preform these actions each time it opens: Automatically unhide any hidded rows (especially...