Lockergnome help - Excel - Setup

Excel starts very slowly

Just a guess Close excel Windows start button|Run Type temp and hit enter Delete all the temporary files that you see there You may have to view the details and stay away from the ones with today s date they could be in use by other programs Then back to excel to test it THIBUS Trvis wrote: > > Hi Everybody > > On a Windows XP computer with Office XP I

Help with Object Library

Go back to your other posting for replies No need to multi post Gord Dibben MS Excel MVP On Fri 6 Nov 2009 09:51:01 0800 Ayo wrote: > I developed an Excel macro but some people can t use it because they don t >have the object libraries needed in their Excel application How do you add >object libraries to your VBA that are missing?

how do i lock cells in exel

You must unlock the contiguous range which you want to filter You must set the Autofilter to enabled before protecting the sheet with Allow users to Use Autofilter Or you can use code to unprotect do the filtering then reprotect Gord Dibben MS Excel MVP On Wed 28 Oct 2009 05:15:01 0700 Faiyaz wrote: > > > funbox wrote: > >I

Can you format cells in Excel by inches? If so how?

Gord Dibben wrote: > Adrienne > > Do you mean as in column widths row heights objects? > > There is no option in Excel for these > > Windows Regional Settings can be changed from Metric to Imperial > > Otherwise > > Any object that is measured in inches or centimeters Text Box Drawing > Object List Box from the Forms Toolbar for instance or Comment Box

set up a stock ordering system in excel working backwards

Couple of methods depending upon how you re set up 1 If entering basket types down column B you could use a cell with a COUNTIF formula for each type of basket In X1 enter =COUNTIF B:B sweet Then in C2:G2 assuming titles in C1:G2 enter = X 1 Same pattern for fruit or canned goods 2 Have Data Validation dropdown list in B2 with fruit sweet and canned goods W

Add a service charge

Is there a template that will calculate sub total then add tax then add a service charge that is non taxed then figure a grand total? Newbie here so please respond so even a simpleton like me can understand how to set it up :

Old Help View

How would this add functionality to a version that dropped what OP needs a couple of versions past? Excel 2002 and newer do not have an Index in their help files Gord Dibben MS Excel MVP On Mon 28 Sep 2009 16:04:31 GMT maxilo via OfficeKB com wrote: >The best way to restore Excel is a software that I found on the web I used >it to repair ms office files do

Staring part of infornation in a columns

Paste the formula Dave posted into C1 Copy the formula down to C10 by dragging the fill handle of C1 Gord Dibben MS Excel MVP On Thu 24 Sep 2009 09:21:03 0700 Redseeing wrote: >Sorry for more questions but how would I make =LEFT A1 4 > >REPT 8 RIGHT A1 4 > >Copy everything from A1:A10 to C1:C10? > > Dave Peterson wrote: >

File format x_master

I have received an excel file in the format x_master and are not able to open it I guess that it has to do with some set up of excel ant VB Thanks in advance

Adding a Close Workspace option when right clicking Excel

Like most users I group applications on the taskbar to conserve space I am able to close all applications I use regularly by right clicking with the sole exception being Excel because I use a workspace with multiple windows spreadsheets I find it convenient to whiz through and quickly close applications by right clicking and selecting Close Group However this option is greyed out

Hyperlink Issue

Hi Check to see if a hyperlink base address has been set in your Excel or the other machines From Excel help Set the base address for the hyperlinks in a workbook By default unspecified paths to hyperlink hyperlink: Colored and underlined text or a graphic that you click to go to a file a location in a file a Web page on the World Wide Web or a Web page on an intranet Hyp

Deleting columns

This is the answer hide the unused columns: Click on the F to select column F While holding Shift hit the End key and then the Right Arrow key this will select all columns from F to the end Format Column Hide or right click on the column headings and pick Hide

highlighting or selecting cells

Assuming you are using Excel 2007 Many users have complained of the same condition No good fix to date but some users have reported a bit of improvement by playing with Windows Display settings Play around with Color Scheme in Appearance options Gord Dibben MS Excel MVP On Wed 19 Aug 2009 13:24:10 0700 joec wrote: >How do I chang

excel missing columns

Also try Window gt; Unfreeze Panes in Excel 2003 I had a similar problem Column A was not visible sheet started at Column B and Unfreezed fixed it Apparently someone probably me : had frozen column A in such a way that it could not be accessed

Turning always save backup file to off

Nothing built into excel You could create a workbook template named book xlt and store it in your XLStart folder Make sure you include all the settings you like in that template In xl2003 a new workbook will be created based on this workbook when you click on the New Icon on the standard toolbar For existing workbooks you could create a macro that you could run that would sav

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.