[1guitarguy]

Does anyone know how to change the A B C columns at the top I can't figure it out

Posted via CB10
Attachment 309936

[hpjrt]

Change them how?


Posted from my BlackBerry Passport

[madcat72]

Press the column you'd like to change, you'll than see a little tab, press and hold till you feel the vibrate, than extend as needed.

Hope this helps.

Posted via CB10

[1guitarguy]

I hear the vibrate but it isn't changing

Posted via CB10

[mnc76]

Initially what you may see. Make sure you are not in "cell edit" mode where you type in text.


--

Click the column you want to stretch by clicking it's letter.


--

Hold down on the graphic that appears just to the left of the column letter until but vibrates.

DO NOT TAKE FINGER OFF SCREEN AFTER IT VIBRATES. Keep your finger on screen in the same spot it was when you got the vibration.

After it vibrates (with your finger still on screen), start dragging the column width.


--

When you get to your desired width, you can take your finger off the screen.


Posted via CB10

[1guitarguy]

No I know how to make it wider my question was is there a way to give the top column a different name (instead of A B C)

Posted via CB10

[blueyestm]

No I know how to make it wider my question was is there a way to give the top column a different name (instead of A B C)

Posted via CB10

I don't think you can, I have to keep changing them on the desktop. I've tried. I cant even change the sheet names.

[hpjrt]

The column letters facilitate formulas and mathematical equations in the spreadsheet. If you could change them your formulas would be a nightmare. Use the first line of cells for your titles. That's a pretty basic rule of spreadsheets in effect since the Lotus123 days.

Posted from my BlackBerry Passport

[spikesolie]

Not even in excel would it be advisable to do this. As someone said, formulas and references would-be F'd

Posted from zee flicking coolest smartphone evah!

[mnc76]

Yup.

I've used Excel extensively for years and have never changed the letters. You use the first row for column headings. You can then freeze the first row so you always see the column headings mi matter how far you scroll down the sheet.

Posted via CB10

[CecilTsunami]

Column letters and numbers can't be changed, not even on a desktop. But thank-you for this thread! I've been pulling my hair out trying to figure out how to resize columns. I did it by accident once and then couldn't remember what I did.

Posted via CB10