corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Geek Day » Excel Help - Easy one...


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Excel Help - Easy one...
Whittie
Member
Registered: 11th Aug 06
Location: North Wales Drives: BMW, Corsa & Fiat
User status: Offline
27th Jan 13 at 17:13   View User's Profile U2U Member Reply With Quote
Top half of my sheet is frozen..

Bottom half (non frozen section) I'm wanting a table, that has different column widths to top half.

How do I alter the bottom half column widths without the top half been affected?

Thanks in advance.
evilrob
Premium Member

Avatar

Registered: 16th Mar 12
Location: Your mum's house
User status: Offline
27th Jan 13 at 17:14   View Garage View User's Profile U2U Member Reply With Quote
Can't be done as far as I'm aware old chap.
evilrob
Premium Member

Avatar

Registered: 16th Mar 12
Location: Your mum's house
User status: Offline
27th Jan 13 at 17:15   View Garage View User's Profile U2U Member Reply With Quote
You could merge cells to achieve the illusion of different column widths.
Gaz
Member
Registered: 24th Aug 03
Location: Widnes, Cheshire
User status: Offline
27th Jan 13 at 17:15   View User's Profile U2U Member Reply With Quote
Can you actually do that? wouldn't you be merging the bottom section of cells together so you don't break the top half?
Whittie
Member
Registered: 11th Aug 06
Location: North Wales Drives: BMW, Corsa & Fiat
User status: Offline
27th Jan 13 at 17:20   View User's Profile U2U Member Reply With Quote
Okay thanks chaps,

If I can't do it that way, is it possible to do a macro from sheet one, to sheet 2? I can split view the sheets can't I?

Basically top part of the sheet is a calculator, bottom is a table. I'm wanting to use a macro to copy the results into the right cell in the table. Can this be done on separate sheets? I'm pretty awful in excel!
evilrob
Premium Member

Avatar

Registered: 16th Mar 12
Location: Your mum's house
User status: Offline
27th Jan 13 at 17:21   View Garage View User's Profile U2U Member Reply With Quote

Gaz
Member
Registered: 24th Aug 03
Location: Widnes, Cheshire
User status: Offline
27th Jan 13 at 17:48   View User's Profile U2U Member Reply With Quote
Alex, can you not just do a simple cum formula and then if you want it on another sheet simple do a reference formula?
evilrob
Premium Member

Avatar

Registered: 16th Mar 12
Location: Your mum's house
User status: Offline
27th Jan 13 at 17:50   View Garage View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Gaz
Alex, can you not just do a simple cum formula and then if you want it on another sheet simple do a reference formula?

FNARR!
Gaz
Member
Registered: 24th Aug 03
Location: Widnes, Cheshire
User status: Offline
27th Jan 13 at 17:56   View User's Profile U2U Member Reply With Quote

 
New Topic
New Poll

  Related Threads Author Forum Replies Views Last Post
is there a program that...... chris_uk Geek Day 6 1906
16th Jun 05 at 00:47
by Dan B		  
Microsoft Excel Kathryn W Geek Day 7 1282
3rd Aug 07 at 12:12
by RyanSxi		  
Need someone with a little Excel knowledge AdZ9 Geek Day 3 526
24th Jun 09 at 20:30
by Ian		  
Microsoft Excel strick206 Geek Day 10 1487
6th Jul 11 at 14:46
by Sam		  
Visual Basic in Excel fiestakidda Geek Day 2 236
13th Sep 12 at 19:31
by James		  

Corsa Sport » Message Board » Off Day » Geek Day » Excel Help - Easy one... 28 database queries in 0.0117500 seconds