quick excel question
01-30-2008, 05:59 PM
#2
Guest
Posts: n/a
well, in office 2007 you can. under the developer ribbon click on insert and choose the check box.
you'll have to add the developer ribbon most likely though. i think in that case you just click on the office logo and then on options. check the "show developer tab in ribbon" and you're good to go!
you'll have to add the developer ribbon most likely though. i think in that case you just click on the office logo and then on options. check the "show developer tab in ribbon" and you're good to go!
01-30-2008, 06:35 PM
#3
Junior Member
Join Date: Aug 2005
Location: North of Buffalo, NY *** NEBF '05, '06, '07 *** ***ONBF & NYBF 06; 07*** ***WCBF 06***
Posts: 1
Likes: 0
Received 0 Likes
on
0 Posts
Which version of excel do you have? I just got the 2007 and haven't figured it all out yet.. I did a quick search through help but came up empty.
What you could do is improvise.... reduce the width of the column you want to use as the checkmark box....and type in an "x" instead of a checkmark for items that are completed.
What you could do is improvise.... reduce the width of the column you want to use as the checkmark box....and type in an "x" instead of a checkmark for items that are completed.
01-30-2008, 06:41 PM
#4
Senior Member
Posts like a Northstar
Join Date: Jul 2006
Location: Waukesha, Wisconsin
Posts: 547
Likes: 0
Received 0 Likes
on
0 Posts
Yes I know for sure that you can. My partner at work is an Excel wiz and can do just about anything. The only thing is that I don't know how to do it myself. Anyways I think he uses Macro'* for the interface that is linked to the sheet that it populates. I know he does a bunch of programming with the Macro'* to achieve this. Just search how to use Macro'* in Excel.
Thread
Thread Starter
Forum
Replies
Last Post
zigmeisterxiv
1992-1999
1
02-10-2010 07:42 PM