need EXCEL help - FMVperformance.com : The site for all your Ford Mazda and Volvo needs
 
LinkBack Thread Tools
post #1 of 5 (permalink) Old 07-24-2007, 01:46 PM Thread Starter
Le Mans: Prototype Class
 
Join Date: Apr 2007
Location: philly burbs
Posts: 1,592
Send a message via AIM to Weaselnoze
need EXCEL help

to insert another column in between 2 columns i used to be able to click the letter of the colomn which would select the whole column then hit insert. now it gives me some error that says 'To prevent accidental loss of data, MS Execl cannot shift nonblank cells off the work sheet'. it wont even let me insert a column far away in the middle of blank cells.


To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
Weaselnoze is offline  
Sponsored Links
Advertisement
 
post #2 of 5 (permalink) Old 07-24-2007, 01:48 PM
gru
F1 Driver
 
Join Date: Jun 2007
Location: Philly, PA
Posts: 3,862
Re: need EXCEL help

Just do this:

Right Click the Column and click "Insert"

Boom! Unless you have something CUT it'll insert a blank column!

Hope that helps
gru is offline  
post #3 of 5 (permalink) Old 07-24-2007, 01:49 PM
Le Mans: Prototype Class
 
Join Date: Jun 2007
Location: Orlando, FL
Posts: 1,387
Re: need EXCEL help

Sounds like you've got data located at the edges of your working spreadsheet. Scroll to the rightmost/bottom-most rows/columns and see.

Once you remove that data, then you should have no problem inserting. Good luck!


To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.

Delete moldings/badges, 15% tint all-around, stubby antenna, open-mouth grille, Eibach Pro-Kit.

To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.

NOS & Lift-kit
johnf514 is offline  
post #4 of 5 (permalink) Old 07-24-2007, 02:06 PM Thread Starter
Le Mans: Prototype Class
 
Join Date: Apr 2007
Location: philly burbs
Posts: 1,592
Send a message via AIM to Weaselnoze
Re: need EXCEL help

i figured it out. it was because i took the very first row and merged all of the cells so it was one big effin cell and couldnt get wider..


To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
Weaselnoze is offline  
post #5 of 5 (permalink) Old 07-24-2007, 02:09 PM
F1 Driver
 
Join Date: Sep 2004
Location: Fulton, MD
Posts: 13,249
Re: need EXCEL help

I love Excel! lol.

Stubby Antenna | 6000k HID Low Beams & Fogs | Angel Eyes | AXXESS iPod Integration Kit | 5% Tint | Trubo's Rims
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.



To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
roxy is offline  
Sponsored Links
Advertisement
 
Reply

  FMVperformance.com : The site for all your Ford Mazda and Volvo needs > Misc > Lounge

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the FMVperformance.com : The site for all your Ford Mazda and Volvo needs forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page



Posting Rules  
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome