Question about Microsoft EXCEL 2004 for Mac

1 Answer

Doesn't remember there's a Header Row

I have a file with a header row that I use in Data/Sort. File suddenly no longer remembers there is a header row or what the previous sort was. How do I get it to "remember"?

Posted by on

Ad

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    President:

    An expert whose answer got voted for 500 times.

  • Master
  • 2,185 Answers

You can try to select all data (except for the entire row which contain your header) and try to sort thru columns. This can sorted in ascending or descending order.

Posted on Jul 21, 2009

Ad

1 Suggested Answer

6ya6ya

6ya staff

  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Need emachines t3306 motherboard connection diagram


The eMachines T3306 desktop computer, uses the FIC K8M-800M motherboard.
First International Computer, (Inc)

http://www.fic.com.tw/product/motherboard/amd/ficimages/k8m-800m.jpg

http://www.fic.com.tw/product/motherboard/amd/k8m-800m.aspx

Here's the download page for the motherboard manual,

http://www.elhvb.com/mboards/OEM/eMachines/manuals/index.html

Column in middle, 3rd file from bottom.

This is a Zip file. A Zip file is a Compressed file. Used to send large amount of information more easily.
Has to be decompressed, or 'unzipped'.

After you click on the blue -> FIC K8M-800M file name, a small window will come up-
Opening K8M-800M_manual.zip

Make SURE there is a Green dot in the small circle, to the left of Save File.
IF not; click in the empty circle to the left of Save File.
No go below in the small window, and click on OK.

A small download window will come up.
Allow the file to fully download all the way, then DOUBLE-click right on the file name.
(Yellow folder icon with a zipper on it. K8M-800M_manual.zip is to the right)

In the next small window go to the far Left, and click on -
Extract all files.
At the bottom of the next 3 small windows click on Next, Next, and Finish.

In the last small window DOUBLE-click right on the file name ->
K8M-800M_manual
(Next to the red Adobe PDF icon)

There is your motherboard manual in PDF file form.

For an example;
The front of your computer is the Front Panel.

The area of contact pins on the motherboard, that the Main wires from the Front Panel go to; is the Front Panel header.

Motherboard installed in computer case, the Front Panel header is at the Bottom/Right.
The Front Panel header is Orange in color. (Page 20)

Two rows of contact pins.
5 pins across the Top row.
4 pins across the Bottom row.

The Top row is numbered ODD.
The Bottom row is numbered EVEN.

Starting on the RIGHT side going across to the Left; Top row,
Pins 1, 3, 5, 7, and 9.

Starting on the RIGHT side going across to the Left; Bottom row,
Pins 2, 4, 6, and 8.

A) Pins 1 and 3 are for the HarDDrive activity LED light.
Pin 1 is for the Positive ( + ) wire.
If the HDD LED is dim when the Harddrive is active, switch the wires around.

B) Pins 5 and 7 are for a Reset switch, IF a Reset switch is used.

C) Pin 9 is N/C. Not Connected.
Reserved for factory use. Probably a 5 Volt test point.

D) Pins 2 and 4 are for a Power On LED light.
These two pins are used for a Single color, Power On LED light.
Two wire LED light.

Pin 2 is for the Positive ( + ) wire.
If the PWR LED is dim when the computer is on, switch the wires around.
There is ALSO a jumper used for this LED light. More on it at the end.

E) Pins 6 and 8 are for a Power On switch.

To the Right of the Orange Front Panel header, (F_PNL), is the PW_LED header.
[Page 20 to right of Front Panel header. -> PW_LED
(Power LED, 2/3 Pins) ]

3-pin Black header. Sits Vertically.
(The Orange - Front Panel header, sits Horizontally)

This is used for a 3-wire Power On LED light.
Used for a Dual Color - Power On LED light.

One example is if the computer has Turbo Mode, and Normal Mode.
Green color usually for the Turbo Mode, Yellow color of the LED for the Normal Mode.

Starting from the BOTTOM going UP;
Pins 1, 2, and 3. (3 at the Top)

A) Pin 1 is for the Positive ( + ) wire. [Signal]
B) Pins 2 and 3 are for the Ground wires.

Jumper block for the 2-wire Power On LED light, and 3-wire Power On LED light; Page 13 - Set System Jumpers
(Actually it starts on Page 12)

6-pin header to right, of 3-wire Power On LED header.
Has Blue jumper caps on it. Two of them.
(PL_LED1)

http://www.ebay.com/itm/NEW-FIC-uATX-Skt-754-AMD-Desktop-Motherboard-VIA-K8M800-AGP-4x-8x-DDR400-800FSB-/280923928691?pt=Motherboards&hash=item41685ef873

Two rows of 3 pins.
The Top row is numbered ODD.
The bottom row is numbered EVEN.

Starting on the RIGHT side going towards the Left; Top row,
Pins 1, 3, and 5.

Starting on the RIGHT side going towards the Left; Bottom row,
Pins 2, 4, and 6.

A) With the jumper caps on Pins 3 and 5; plus 4 and 6; the Power On LED light works as a Single color LED.

B) With the jumper caps on Pins 1 and 3; plus 2 and 4; the Power On LED light works as a Dual color LED.

For additional questions please post in a Comment

Regards,
joecoolvette

Mar 07, 2013 | Computers & Internet

1 Answer

Do you have any user manual for front panel usb


http://www.msi.com/product/mb/PM8M-V.html

(MSI PM8M-V H, is version 2.0 )

Hover your mouse cursor on the Download tab.
(Overview / Specification / Download / Support / etc.)

In the drop down list, click on - Manual
Under the subheading - Download, click on the blue -
M7104v1.0.zip

[ This is a Zip file. A Zip file is a file that is compressed, to send easier. The above manual is for the M7104v1.0
It will work for the version 2.0 also.

You need a program to 'Unzip' it. (Decompress)
If WinZip is not working on your computer, go to 7-Zip, and download for free.
If you need guidance in downloading, and unzipping, post back in a Comment ]

There are two USB headers on the motherboard for the Front Panel,
JUSB1 and JUSB2. (Junction USB 1 and Junction USB 2)

Looking along the bottom of the motherboard, FROM the Right going towards the Left;

JFP1 header; (Front Panel main wires)
Header with 4 pins on the Top row, and 5 pins on the Bottom row.

JFP2 header; (Dual color Power On LED, and Speaker)
Header with 4 pins on the Top row, {Speaker}, and 3 pins on the Bottom row.

JUSB2 header.

JUSB1 header.

EACH USB header will support TWO USB ports in the Front Panel.
JUSB1 supports two,
JUSB2 supports two.

For each USB header there are 5 pins across the Top, 4 pins across the Bottom.
The pins are numbered EVEN across the Top, and ODD across the Bottom.

Starting from the LEFT side going across to the RIGHT side;
on the TOP row for JUSB2 and JUSB1;
Pins 2, 4, 6, 8 and 10.

Starting from the LEFT side going across to the RIGHT side;
on the BOTTOM row for JUSB1 and JUSB2;
Pins 1, 3, 5, and 7. There is NO pin 9.

A) Pin 2 is VCC
B) Pin 4 is USB1-
C) Pin 6 is USB1+
D) Pin 8 is Ground

E) Pin 10 is USBOC

Pin 10 is N/C -> Not Connected.
It is there, and Pin 9 is not there, to key which way a connector can go on. Only ONE way.

F) Pin 1 is VCC
G) Pin 3 is USB0-
H) Pin 5 is USB0+
I) Pin 7 is Ground

There is NO pin 9.

(The USB technology used is USB 2.0)

http://pinouts.ru/Slots/USB_pinout.shtml

Let's read together,
Under - USB pinout signals;

"USB is a serial bus. It uses 4 shielded wires: two for power (+5v & GND) and two for differential data signals (labeled as D+ and D- in pinout). NRZI (Non Return to Zero Invert) encoding scheme used to send data with a sync field to synchronise the host, and receiver clocks. In USB data cable Data+ and Data- signals are transmitted on a twisted pair. No termination needed. Half-duplex differential signaling helps to combat the effects of electromagnetic noise on longer lines. Contrary to popular belief, D+ and D- operate together; they are not separate simplex connections."

See the USB examples in the link above, where it labels the contact pins?
The MALE connectors are shown on the Left side.
The FEMALE connectors are shown on the Right side.

Your USB ports will be FEMALE, on the Front Panel.
They are also the A style. USB A style. The Top example to the Right.

Just noting the following in case for some reason, the wires coming from those contact pins in the female USB connector, are not color coded correctly;

Even after you have the wires sorted out, as to which contact pins they go to, DOUBLE-check again. Do NOT just go by the color code of the wires.
Why?

You do NOT want to accidentally connect the +5 Volts (VCC), to the Ground!

Explaining further;
You connect the VCC wire, (Red), of the USB port in the Front Panel, to the Ground pin on the USB header on the motherboard.

(Which means the Ground wire of the USB port, (Black), will probably also be connected to the VCC pin, on the USB header of the motherboard)

Zzzzzzap! There goes your front USB ports. Both USB front panel headers on the motherboard, will be DONE!

Make sure!

Going on;
1) VCC or Vcc, goes back relating to Transistor technology.
Just think of it as the Positive, or power wire.
It is.
It is 5 Volts DC.

2) GND is Ground. It's a DC circuit, and you have a Positive, and a Negative, or Ground.

3) USB1-
That is -> Data-

USB0 is for one USB port in the Front Panel.
USB1 is for another USB port in the Front Panel.

[ Each USB header on the motherboard can be connected, to TWO USB ports on the Front Panel.
Therefore for the two JUSB1 and JUSB2, you can connect Four USB ports in the Front Panel ]

Data- on one USB port in the Front Panel, goes to USB0-

Data- on the other USB port in the Front Panel, goes to USB1-

4) Data+
Same thing.
Data+ on one of the USB ports in the Front Panel, goes to USB0+
Data+ on the other USB port in the Front Panel, goes to USB1+

EACH side of JUSB1 and JUSB2, will support one USB port on the Front Panel.
Two sides per JUSB1 and JUSB2 = 4 USB ports on the Front Panel.

For additional questions, or clarification to anything I have stated above, please post in a Comment.

Regards,
joecoolvette

Jul 20, 2012 | MSI Computers & Internet

2 Answers

Recover deleted items


I suggest you recover all your deleted files and then sort out what you want and then delete the unwanted files before you back up your data.

Jul 09, 2012 | Computers & Internet

1 Answer

When I try to merge my excel document with 250


Hi deloisr

It looks like you have chosen the wrong data file. Probably an earlier version of your data still present in some folder.
Check these
Do you have column headings for every column?
Make sure which folder contain the file? What exactly is the name?
When you are in the Microsoft word, make sure you select the correct data file for your mail merge. If you have selected the correct data file, when you attempt to insert the merge fields, there is no way, it give wrong field names.
The only reason you get the erong field names is because you have the wrong excel file for your data. Fix this problem first, then the rest will sort themselves out.
Have a good day.
luciana44

Nov 09, 2009 | Microsoft Computers & Internet

1 Answer

How do you print envelopes?


More information is required so I will only assume you are using Excel as a database. Excel is a spread sheet program used by accountants or for mathematical formulas and ledgers. Access is the Database program, however, Excel has functions which is faster to sort and work with address, phone number, zip codes. I will confess, I use Excel as Database because it is quick and easy. I do not know what version of Excel you are using so I will describe it from Office 2007. From Excel make sure you have headers above each column i.e. First Name in Cell A1 Last Name in Cell B1 Address in Cell C1 ect.

Make sure your data is correct and case sensitive as you would like it. If you want zip+4 select the Colum and right click to format the cells using special and select Zip or Zip+4.
It is easiest to use Microsoft Word for the next step rather than format the cells, add page breaks, and customize the print size.
Save your document as an Excel document where you can find it to import it into Word.
Open word and select Mailings then Start Mail Merge and Step by Step Mail Merge.
Select Envelope and next. Select envelope options to change envelope size, font and print options.
Click on Next Select recipients.
Click on browse under select an existing list.
Select the Excel file with your address information.
From the Select Table check the First row of data contains column headers.
Click on the OK buton.
Arrange your envelope then Preview it and your good to go.
If you have an older version of word selects Tools and click on Mail Merge.
Select Get Data.
Pull down Excel for document type.
Select entire Spread Sheet.
Layout your document and complete the merge.
On old versions of word it may not recognize the Excel file. If this happens open the Excel file and save it as a Database File (.dbf) and it should work.
I hope this helps since I did not have enough information from your question.

Jul 15, 2009 | HP OfficeJet 6110 All-In-One InkJet...

1 Answer

Autofilter ceases to work on large Excel 2003 spreadsheet


Sounds like there is a gap between the filter heading and the column data. That's the only time I've seen suggested data missing from the drop-down.

Jun 16, 2009 | Microsoft Computers & Internet

1 Answer

Convert mdb to text files with vb 6.0 code


You will need to open the file using ADO and read the data into a recordset. Then loop through the rows and write them to a text file and use concatenation to format the rows in the text file as needed (CSV, tab delimited, whatever you need). Remember to add a vbCrLf after each row!

Apr 10, 2009 | LEAD Technologies Computers & Internet

1 Answer

I have done something in my spreadsheet ... many icons are dimmed. For example, under the Insert tab, all the icons are dimmed except for Header & Footer, and Signature line. If I open a new file, the...


It sounds like the file is "read only". Open the file and save under a new name, or right click the file name and select properties. Then make sure the "Read only" box is cleared. The file could also be protected. Go to the review tab and sele "Ptotect Sheet" in the changes group. If the is no password, the sheet will be unprocted when you click the icon.

Feb 10, 2009 | Microsoft Excel for PC

2 Answers

How to recalling my files before i saved


just try to check where you saved your file.... if you dont know it then try to search the file using the file name in windows search.... it might be hidden at times.. if so then try to enable hidden files in folder options.... suppose you have not saved the file as and when you made changes then also the file can appear to be mistaken

Sep 26, 2008 | Microsoft Windows XP Professional for PC

1 Answer

STECH 320GB Corrupt Boot file


sure..take it to a recovery expert..they love this sort of work..not cheap..but highly effective..

and you may wish to consider backing up that external drive in future.

May 25, 2008 | SimpleTech 250GB USB2.0 7200 RPM External...

Not finding what you are looking for?
Microsoft EXCEL 2004 for Mac Logo

Related Topics:

70 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

ThaMp3Doctor
ThaMp3Doctor

Level 3 Expert

8597 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...