|
|
|
|
elkid
Member
|
|
|
Joined: 18 Nov 2002
Posts: 8353
Location: hiding out in Philly
|
| Back to top
|
|
 Posted: 03/26/03 - 16:28 Post subject: One Day Asylum: Microsoft Office Questions
... from the corporate trainer. No question too big or small.
FYI: Word, Excel, PowerPoint, Outlook answered very quickly ... due to recent SQL work, Access may take a few minutes.
|
|
|
|
|
shelflifers
Member
|
|
|
Joined: 10 Jun 2002
Posts: 18633
Location: Austin, TX
|
| Back to top
|
|
Posted: 03/26/03 - 16:32 Post subject:
On Excel, if I need the top line to stay PUT while I cruise down my list, how do I do that?!
|
|
|
|
|
purple hayes
Frightened Inmate #2
|
|
|
Joined: 14 May 2002
Posts: 14462
Location: ON YOUR LEFT!
|
| Back to top
|
|
Posted: 03/26/03 - 16:37 Post subject:
Did you ever 'play' the Doom-type game that was embedded in Excel '95?
|
|
|
|
|
elkid
Member
|
|
|
Joined: 18 Nov 2002
Posts: 8353
Location: hiding out in Philly
|
| Back to top
|
|
Posted: 03/26/03 - 16:38 Post subject:
| shelflifers wrote: | | On Excel, if I need the top line to stay PUT while I cruise down my list, how do I do that?! |
Click on the row below the one you want to be the last stay PUT line (yes, you can do multiples) and select Window, Freeze Panes from the menu bar.
Hint: you can also freeze columns this way, too. EX. cursor in cell C3 - you will freeze rows 1 & 2 and columns A & B. Supah great for data entry, particularly for running logs.
|
|
|
|
|
elkid
Member
|
|
|
Joined: 18 Nov 2002
Posts: 8353
Location: hiding out in Philly
|
| Back to top
|
|
Posted: 03/26/03 - 16:38 Post subject:
| purple hayes wrote: | | Did you ever 'play' the Doom-type game that was embedded in Excel '95? |
No. I left that to the geeky LAN guys. 
|
|
|
|
|
shelflifers
Member
|
|
|
Joined: 10 Jun 2002
Posts: 18633
Location: Austin, TX
|
| Back to top
|
|
Posted: 03/26/03 - 17:01 Post subject:
| elkid wrote: | | shelflifers wrote: | | On Excel, if I need the top line to stay PUT while I cruise down my list, how do I do that?! |
Click on the row below the one you want to be the last stay PUT line (yes, you can do multiples) and select Window, Freeze Panes from the menu bar.
Hint: you can also freeze columns this way, too. EX. cursor in cell C3 - you will freeze rows 1 & 2 and columns A & B. Supah great for data entry, particularly for running logs. |
Thanks, KID!! That rules! My spreadsheeting skillz needs some polishing...
|
|
|
|
|
elkid
Member
|
|
|
Joined: 18 Nov 2002
Posts: 8353
Location: hiding out in Philly
|
| Back to top
|
|
Posted: 03/26/03 - 17:03 Post subject:
| shelflifers wrote: | | Thanks, KID!! That rules! My spreadsheeting skillz needs some polishing... |
Then shoots away ... you gots a day.
|
|
|
|
|
Cappy
Excelent
|
|
|
Joined: 16 May 2002
Posts: 27368
Location: Spreadsheetylvania
|
| Back to top
|
|
Posted: 03/26/03 - 17:08 Post subject:
| shelflifers wrote: | | Thanks, KID!! That rules! My spreadsheeting skillz needs some polishing... |
and you're married to a spreadsheeter, 
|
|
|
|
|
shelflifers
Member
|
|
|
Joined: 10 Jun 2002
Posts: 18633
Location: Austin, TX
|
| Back to top
|
|
Posted: 03/26/03 - 17:12 Post subject:
| Cappy wrote: | | shelflifers wrote: | | Thanks, KID!! That rules! My spreadsheeting skillz needs some polishing... |
and you're married to a spreadsheeter, |
Cappy for the hundredth time, we're just friends, buddy...DOH! you meant Joy...my bad...
|
|
|
|
|
ShannonG
Member
|
|
|
Joined: 20 Mar 2003
Posts: 4858
|
| Back to top
|
|
Posted: 03/26/03 - 17:29 Post subject:
What does this large red button labeled SELF DESTRUCT do?
|
|
|
|
|
elkid
Member
|
|
|
Joined: 18 Nov 2002
Posts: 8353
Location: hiding out in Philly
|
| Back to top
|
|
Posted: 03/26/03 - 17:35 Post subject:
| ShannonG wrote: | | What does this large red button labeled SELF DESTRUCT do? |
It saves your work and automatically sends it to the printer. 
|
|
|
|
|
shelflifers
Member
|
|
|
Joined: 10 Jun 2002
Posts: 18633
Location: Austin, TX
|
| Back to top
|
|
Posted: 03/26/03 - 17:38 Post subject:
| ShannonG wrote: | | What does this large red button labeled SELF DESTRUCT do? |
This one?
|
|
|
|
|
cherylpf
crazy cat lady
|
|
|
Joined: 14 May 2002
Posts: 17304
|
| Back to top
|
|
Posted: 03/26/03 - 18:51 Post subject:
only one day???? can you just pull up a chair in my cube here? It may take a while. I don't have anything right now, but thats because I don't have a spreadsheet open....(which is rare...)
|
|
|
|
|
elkid
Member
|
|
|
Joined: 18 Nov 2002
Posts: 8353
Location: hiding out in Philly
|
| Back to top
|
|
Posted: 03/26/03 - 19:35 Post subject:
| cherylpf wrote: | | only one day???? can you just pull up a chair in my cube here? It may take a while. I don't have anything right now, but thats because I don't have a spreadsheet open....(which is rare...) |
For you, I might make an exception. And not just for Excel either!
|
|
|
|
|
sidewinder
Member
|
|
|
Joined: 28 Aug 2002
Posts: 309
Location: Peoria, AZ
|
| Back to top
|
|
Posted: 03/26/03 - 20:13 Post subject: Re: One Day Asylum: Microsoft Office Questions
| elkid wrote: | ... from the corporate trainer. No question too big or small.
FYI: Word, Excel, PowerPoint, Outlook answered very quickly ... due to recent SQL work, Access may take a few minutes. |
How do I create a subform in Acces to enter a quantity then multiplty that times the list price and the customer's discount level in creating a quoting routine? Description & list data to come from products table.
Thanks
|
|
|
|
