Any MS Excel Gurus? - DFWstangs Forums
 
LinkBack Thread Tools Display Modes
post #1 of 2 (permalink) Old 01-11-2008, 03:19 PM Thread Starter
Lifer
 
ShawnQ's Avatar
 
Join Date: Jun 2001
Location: Owensboro, KY
Posts: 3,794
Any MS Excel Gurus?

I'm trying to figure something out in Excel.

I have a database with about 7 colums and unlimited rows.

Each Row will be assigned to a certain job # here at our company, and there will be info in each cell pertaining to that job.

What we want to be able to do is insert a 'notes' area that is normally hidden, but can be activated when desired. I know about the comments function, but I am looking for actual cells that can be activated, and not a comment box.

In other words, if I have one job # that I want to leave a comment for, I want to click on that job number, and have a few rows open up beneath it that are empty and allow me to type notes in them.

Is this possible?

The comments function will work, but it is a little tedious because you have to active it with a right click, edit comment, hide comment, etc. I'd like to be able to just mouse over and start typing.

Any help is appreciated.
Any other suggestions are also useful!

Thanks,
SQ

Semper Paratus - Proudly serving in the USCG
----------------------------------------------------------
1991 LX Coupe 5.0 - Bimini on Black - Mostly stock Weekend driver
1985 LX Coupe 5.0 - Still in pieces
2008 Nissan Rogue SL AWD Premium - Wife's Ride
ShawnQ is offline  
Sponsored Links
Advertisement
 
post #2 of 2 (permalink) Old 01-11-2008, 03:24 PM
Lifer
 
Join Date: Jul 2000
Location: Rowlett, TX
Posts: 1,463
How about just hiding the cells? Just highlight the column you want hidden, then right click in the column and click "hide"
Way Cool Jr is offline  
Sponsored Links
Advertisement
 
Reply

Bookmarks

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the DFWstangs Forums 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
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may 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 On
Trackbacks are On
Pingbacks are On
Refbacks are On

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