Lockergnome help - Excel - Excel General (archive)

How can I have an initial zero in an Excel cell?

Simply format the cell Select custom and type in hh:mm and click OK DONE

How do I change the width of the data validation list box?

Simply create the list in a merged cell Excel 2007 Ribbon_Home Alignment Merge Cells and merge over 2 or more cells for the list width required and then create your data validation list box

Inserting blank rows in Excel

You re making this WAY too complicated You don t need a macro Add a column to the left or right of your data It doesn t matter where In the first cell type 1 In the second cell type 2 Grab both cells and drag to the bottom row of your data Excel will number your rows as 1 2 3 etc While all of this column is highlighted select copy Ctrl C then go down to the first empty row and

Rename all existing worksheet tabs

Hi I would like to rename all worksheets in a workbook but pull the name information from a list range on a page Thanks Martyn

Problems Creating a Dynamic List Box in Excel

I m trying to create a list box that only show certain values depending on certain criteria So I have: A B 1 Bob 1 Dave 1 Mike 0 Danny 1 Steve 0 Adam I want to make a list box of all the names in column B where the value in column A is greater than 0 Help?

Excel Add In fails when Worksheet inserted in Word document

I have written an Add In for Excel Outlook amp; Word well 3 separate very similar ones Now I have a hiccup A user decided to insert an Excel Worksheet object into a Word document and my Excel Add In fell over It tried to change either a command bar or the DisplayAlerts property in Excel which depends on version and the inserted object doesn t have allow the bar property Is the

Pivot Table Remove Calculated Item

I accidentally inserted CALCULATED FIELD into my pivot row instead if inserting CALCULATED FIELD in the data area Have a month Formula1 made the pivot look bad and it was cumbersome to HIDE that item on each pivot copy How do I remove or delete it from the pivot s cache memory? I didn t find any direct answer with a quick search but I did figure something out and thus I m posting the a

How to stop an auto carriage return importing a flat file

I m trying to import a flat data file meant to be sent to another system A character is causing a carriage return and one line of data turns into two The character is computer generated it looks like a squared off zero It also happens if I cut and paste the file the sort data to columns I can t do a find and replace because I can t recreate the character and it will not cut and p

Lookup or if statement questoin

If I have data that looks like this Bob 5 Sarah 6 Bob 7 Sarah 9 leslie 8 Is there a function that I can use that will esentially add up all of bob then sarah then leslie? then if I change the name Bob to Leslie it will automatically change the summation of bob So it looke like Bob 12 Sarah 15 Leslie 8

Opening excel files where is the file

Hey I may be having a similar problem When I open an excel file from the explorer window excel will open but the file will not From there I can change the size of the window and then the file loads automatically I tried both the above and it still does not open excel files through explorer until I change the window size Thanks

Is there an easy way to swap the contents of two cells in

The code to swap the cells works great but I need the colors of the cells to swap as well Any way to accomplish that without rerunning the macro that color coded the cells in the first place?

Can not open excel files without open application

Hi Just post to hope this will help in the future Seems that the files are damaged you can try a tool called Advanced Excel Repair I have used it to repair many corrupt Excel xls files successfully Its homepage is http: www datanumen com aer Alan

Spreadsheet archived ?

Hi A spreadsheet which has been used regularly for months now seems to be locked If a number is entered into an empty cell it should also alter the value in the total box at the foot of the column The new entry is seen but the total remains unchanged Have checked that the formula includes that cell Any suggestions? Thanks

Excel left click produces right click menu

highly irritating But then i remembered that excel can be very responsive to the escape key and it worked for me I put the cursor in an empty cell and no more right click menu for left click hope that helps someone :wink:

Is it possible to link 2 spreadsheets with v lookup

To create a spread sheet that auto fills information from another spreadsheet by using v lookup What I would like to do is enter into one field the name of the excel work book and have the v lookup and be an = function to the field I want it to point to so I can store multiple data on one sheet with out have to manually create it IE if my n

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.