ST Alpha - "I hate new excel. how the HELL do i change a column width? why can't i just grab and drag? grrr -- nm" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 160

I hate new excel. how the HELL do i change a column width? why can't i just grab and drag? grrr -- nm

Posted by Andie (aka Andie) Apr 29 '10, 06:40

(No message)

Responses:

I hate technology in general, especially any sort of wireless and anything involving Comcast. -- nm - ty97 Apr 29, 07:07
Sounds like someone locked the sheet? go to the Review tab, and see if the "Protect Sheet" or "Protect Workbook" are clicked/depressed? -- nm - JaxSean Apr 29, 06:57 2
- If you want, you can gmail it to me and I can see what's going on. -- nm - JaxSean Apr 29, 07:09 1
  - thanks, but just copying it to a new document created in 2007 seems to have solved my issue. just so annoying! -- nm - Andie Apr 29, 07:10
I'm not having a problem with this in 2010, and never had a problem with it in 2007. - scorpion Apr 29, 06:46 4
- i think it's a conversion issue. -- nm - Andie Apr 29, 06:47 3
  - It could be, but I use workbooks that were mostly created in 2003.....might be something odd about that one sheet /shrug -- nm - scorpion Apr 29, 06:48 2
    - column width is something that can be locked in Excel. Maybe it was locked in the 2003 file. -- nm - Beryllium Apr 29, 06:55 1
      - wasn't though. -- nm - Andie Apr 29, 06:58
Click the top of the column, so you highlight the whole thing, then right click and you get Column Width as a selection. -- nm - Jim Apr 29, 06:44 21
- interestingly, if i open a new blank document, i can move them, but i can't on a document i imported from 2003. grrr -- nm - Andie Apr 29, 06:45 20
  - so, now that i know that, i just C&P'd the whole thing to a new doc and it works. (it worked fine in my old program....) -- nm - Andie Apr 29, 06:47 19
    - Working between the 2 kinda sucks...but now that I'm used to 2007...I like it a lot more. -- nm - Jim Apr 29, 06:47 18
      - I'm with you. Now that I use it all the time, I like it *a lot* more than 2003. -- nm - JaxSean Apr 29, 06:58
      - Really? I honestly have quit working on Access db's I created becuase I hate 2007 so much. - Will Hunting Apr 29, 06:50 16
        
        Haven't worked with Access 2007. I was just talking Excel. -- nm - Jim Apr 29, 06:55 14
        
        I think they're deliberately making Access more crap with each release so they can retire it. -- nm - scorpion Apr 29, 06:56 12
        
        Could be. The Express version of SQL server is free -- nm - zork Apr 29, 06:59 11
        
        Yup, and far superior. Only problems is, creating interfaces for an SQL DB is a bit more complex. -- nm - scorpion Apr 29, 07:00 10
        
        I have to get into this program. Limits of being self-taught are showing. -- nm - Will Hunting Apr 29, 07:06 7
        
        I'm 100% self taught. Just have to be diligent about setting a shit load of time aside for teaching your self in the beginning - scorpion Apr 29, 07:11 3
        
        Any books or anything you recommend? - Will Hunting Apr 29, 07:13 2
        
        Good question. I have a bunch of tech books for server systems, but I've never purchased one for programming. - scorpion Apr 29, 07:17 1
        
        Sounds good, thanks. - Will Hunting Apr 29, 07:30
        
        do you need to learn SQL or you know it already? -- nm - zork Apr 29, 07:10 2
        
        I'm working my way through a fair bit of it in some of my current db's. - Will Hunting Apr 29, 07:12 1
        
        VB is pretty close to VBA, if you know VBA...it's not an impossible leap -- nm - scorpion Apr 29, 07:14
        
        you could use visual studio express to create web forms so users aren't tied to having Access installed on their machines -- nm - zork Apr 29, 07:05 1
        
        Yea. With Vsiual Basic Express, it's not as much of a leap as it used to be to jump from Access to SQL -- nm - scorpion Apr 29, 07:08
        
        Okay. I just wonder why they changed so drastically the basics here - Will Hunting Apr 29, 06:55
        
        Access 2007 is crap....I think the rest of the apps are light years ahead of '03 IMHO -- nm - scorpion Apr 29, 06:51
What about double-clicking on the column edge? Does that still auto-widen? -- nm - Will Hunting Apr 29, 06:41 1
- that DOES give me the four-way arrow, but i can't actually move it. so, very handy. -- nm - Andie Apr 29, 06:43
i don't have it, but does right click -> column width get you there? -- nm - TFox Apr 29, 06:41 3
- sadly, no. ( i was briefly hopeful) -- nm - Andie Apr 29, 06:42 2
  - Are you dragging the column in the section where you enter numbers, or at the top where the column letter is? - Guigue Apr 29, 06:43 1
    - tried both -- nm - Andie Apr 29, 06:43
I despise Office 2007. I got a Professional Edition for $20 thru my company and I think I overpaid. -- nm - Will Hunting Apr 29, 06:41 8
- I have that at home too. Thank God they left 2003 on our work computers when they upgraded us... -- nm - znufrii Apr 29, 06:41 2
  - We're being told 07's the new standard we're moving to. That's one positive about being laid off. -- nm - Will Hunting Apr 29, 06:42 1
    - I'm pretty sure the departments that got upgraded to Vista all got '07. - znufrii Apr 29, 06:45
- i'm with you guys. -- nm - prayformojo Apr 29, 06:41
- i seriously can't figure out the most SIMPLE actions. -- nm - Andie Apr 29, 06:41 3
  - Really?? nm - Dignan, feigning surprise Apr 29, 06:42 2
    - i'll send you the document mister smarty pants. -- nm - Andie Apr 29, 06:43 1
      - Please do!! nm - Dignan, feigning interest Apr 29, 06:45

Post a message top

Replies are disabled on threads older than 7 days.