Lockergnome help - Excel

Merged cells won t Autofit row height

Hi When you protect your worksheet there are some options to allow for the user One of the options is to format rows So you can autofit rows when protecting your sheet

Freeze at the top split the side in Excel97?

No version of Excel has allowed a split and a freeze panes together so your recollection is faulty The freezing rule is everything left of and above the selected cell will be frozen Select B2 and freeze panes to get row 1 and column A frozen Gord Dibben MS Excel MVP On Sun 22 Nov 2009 17:07:14 0800 PST SlickRCBD wrote: >Is it not p

vlookup in a chart

Can you bee a little more specific? best wishes Bernard Liengme Microsoft Excel MVP http: people stfx ca bliengme Lottie wrote in message news:6A5802C0 EDC3 429A BDEC DFB73821461F@microsoft com >I am trying to create a chart which looks up a value and then depending on > this value uses a certain set of data to draw the chart I know it c

Autofilter Problem

If you changed the format of the cell to an unambiguous date format like mmmm dd yyyy and the cell still displayed yyyy mm dd then the value isn t really a date it s just text masquerading as a date If your offending data is all in a single column you can use this technique to convert the text dates to real dates Select the column Data|Text to columns xl2003 menus fixed wid

Removing Query Definition

In Excel 2003 I was able to remove the query definition once I had imported data from an Access database by de selecting the Save Query Definition from within the Data Range Properties How can I do this in Excel 2007 please Thanks

Excel 2007 gives Configuring message everytime it is started

Hi After installing MS Office 2007 Enterprise on a Vista Pc a friend of mine gets a message Configuring Excel everytime he opens the application the other Office applications he uses do not give this message Please can anyone help? Regards John Dean

Excel 2007 Solver Internal Error When Generating Answer Re

Hi all Even i have faced this problem But i found the way to work with it when you hit the solver button to solve it gives us the strange message BLAH BLAH An unexpected internal error occurred or the available memory was exhausted 1 open the excel and save ctrl s your file current document 2 open the solver give the input tgt cell deci var etc 3 hit the solver button

Excel formula

Thanks it worked Dave Peterson wrote: > I d use another column > > With your list starting in x2 headers in X1 then duplicate the headers in y1 > and use a formula like: > > = = x2 > and drag down > > Then use this helper column as the advanced filter criteria range > > sleepless wrote: > > > > I have a list of about 400 last names that I want to use to find in

Excel 2007 crashes on exit

I ve been dealing with this problem for a week I ve almost tried to go back on a 2003 version but I rather decided to find help over the internet However most of the people think that the problem is in one file but it isn t For me Gomer gave us the only solution Bluetooth was a problem So when I got rid of the Bluetooth Add in Excel was working and still working just fine Gomer th

How to insert the tab name in a cell

Hi You may download and install this addin and then use the sheetname function http: www download com Morefunc 3000 2077_4 10423159 html Regards Ashish Mathur Microsoft Excel MVP www ashishmathur com Kate Bj wrote in message news:E001DBFA D13A 42CC A942 7C5CE58FC9D0@microsoft com > Could anyone please tell how I add the tab na

Formula for finding an element

You re welcome Thanks for the feedback Biff Microsoft Excel MVP bim bom wrote in message news:he9jqm aa2 1@news onet pl > T Valko pisze: >> One way >> >> Array entered : >> >> =INDEX C1:C3 MATCH 1 IF A1:A3=5 IF B1:B3=6 1 0 >> >> array formulas need to be entered using the key combination of >> CTRL SHIFT ENTER not just ENTER Hol

import file so that it is a actual csv file no excel cell

Burt Try changing the file extension from csv to txt before using Excel s file open command That should take you through a dialog HTH Bernie MS Excel MVP broncoburt wrote in message news:19EE91B8 E3E9 467E B746 C9742C64E3D8@microsoft com > How can I import a spreadsheet file from finance yahoo com for the history > prices of a

sum to = 1 for each cell

Mike wrote: > I am trying to sum up 37 cells to = 1 each for each cell ex if i put say > 997 > in cells i want them to = 1 each so that the sum total = 37 if i put 997 > or > any other in cells =COUNT A1:A37

Too many IFs but what do i use?

Im pretty rubbish when it comes to excel but i have a basic code that was working fine but i need add more IF statements too it but i cant =IF B5=1 Sheet2 B 2 IF B5=2 Sheet2 B 3 IF B5=3 Sheet2 B 4 IF B5=4 Sheet2 B 5 IF B5=5 Sheet2 B 6 IF B5=6 Sheet2 B 7 If anyone can help me it would be great :D Sam

VLOOKUP would begin one row below what the first one found?

Hi Mike Thanks a zillion it worked i did not press crtl shift and enter thanks Regards Leong David wrote: VLOOKUP would begin one row below what the first one found? 21 Nov 09 Hi Mike Thanks a zillion for the suggestion But it did not work got NUM error for the first formula after changing AV to aston villa and over for the second formula which should output

How to Handle Remote Tech Support

chris@lockergnome.com (Chris Pirillo) — Mon, 13 Jul 2009 06:30:00 GMT

Using GoToAssist is the easiest way to view and control another person's computer online. Use it to provide instant technical support to family, friends and customers. Start a session with just one click, and instantly connect with the other party.

Network Tools for Windows

chris@lockergnome.com (Chris Pirillo) — Mon, 25 Feb 2008 06:30:00 GMT

You need these network tools, no matter which operating systems and networks you have to support. SolarWinds ipMonitor: Affordable Network Monitoring for SMBs. Get turnkey network, server and application availability monitoring with SolarWinds ipMonitor v9.0. This easy-to-use, reliable solution for SMBs delivers out-of-the-box availability monitoring so you always know exactly what's up with Active Directory, DNS, Exchange, FTP, Web, IMAP, MS SQL Server, and SMTP. Download your free trial today. Or, try their totally free tools! And, through 2/29, save 20% when you purchase ipMonitor 9.0.

Get Your Own Web Site

chris@lockergnome.com (Chris Pirillo) — Mon, 25 Feb 2008 06:30:00 GMT

Starting at just $3.99/month, web hosting from GoDaddy includes 99.9% uptime, 24/7 support and free access to GoDaddy Hosting Connection, THE place to install over 30 FREE applications sure to help you get the most from your hosting plan and Web site. Enter code CP2 at checkout, and save an additional 10% on any order.

Plus, as a friend of Chris Pirillo, enter code CHRIS7, that's C-H-R-I-S and the number 7, when you check out, and save an additional 10% on any order. Get your piece of the internet at GoDaddy.com.

VMware and Parallels for Virtual Machines

chris@lockergnome.com (Chris Pirillo) — Mon, 25 Feb 2008 06:30:00 GMT

It doesn't matter if you're running on Windows or Mac OS X - every power user needs either Parallels or VMware (or both). There's never been an easier way to test software without destroying your primary operating system's stability. Think of how many times you wish you could press a 'reverse' button on your computer. Plus, there's no easier way to try new Linux distributions - see what all the fuss is about. Run Windows in OS X, run Linux in Windows, but the best way to do either is with VMware and/or Parallels.

Coupons for Online Shopping

chris@lockergnome.com (Chris Pirillo) — Sat, 12 Jul 2008 07:56:13 GMT

This feed is fueled by Lockergnome Online Shopping and Coupon Codes

Before you shop next time, see if we have a coupon first.