When I click on a cel in my Excel spreadsheet the cell is not outline in black instead it is a clear outline?
595368
first it depends on what year your excel is ... there are more options in the more recent ones ... however this isnt a normal case ... i would go to control panel then add/remove programs then i would change the program ... which basically reinstalls it back to default ... thats what i would do ... if that doesnt work ... reinstall it with the disk (i hope you have) but dont delete it just repair it \n\nskyler
923656
I know Excel inside & out...and I would love to help you, but I really cant understand what you are asking for.\n\nSo - you are trying to find the picture. OK. Pictures are handled as graphics on a different layer. They are not tied directly to cells or formulas. It should be clearly visible\n\nTry this: select all (Ctrl-A) go to the edit menu, select Clear > Formats. Now, in the format menu,  row > unhide, row > autofit, and Column > unhide, Column > autofit.\n\nThat should open up your entire worksheet. If something is there, you should see it.
399337
Highlight B5 in the formula and press F4.\n\nThis will turin it into an absolute formula $B$5 and will remain fixed.\n\nThe other thing you can do is give the cell reference a name (e.g.B5VALUE) and this can be encorporated in formulaes on any worksheet.  This is an example of a named cell reference.\n\nSee source for more details.\n\nHope this helps
834986
Use conditional formatting\n\nhttp://www.contextures.com/xlCondFormat01.html
326425
Make sure you have a color printer defined and set as default printer in excel. Wierd, I know!
400717
To select all errors on a worksheet, Edit, Go To, Special. Select formulas, and unceck all formula options except 'errors'. Click OK.\n\nNow you have all the error cells selected, you can change the background color to something easy to find, like yellow. All the errors will then be in yellow.
955968
I don't mean to sound like a smart A@##, but are you sure they are grey?  I went to Word to see if I could see what you were talking about, and after setting it up, I could see what you mean, that they appear grey, but once printed, they were black.  Page numbering is computed text, and usually, computed text is greyed out when editing.\n\nIn the font attributes, when you open view -> header footer and insert the page number, highlight it, right-click, and go to font.  One selection there is color (which defaults to automatic).  Even if you change the color to bright green, once you close, the color on the screen is light grey.  Go to print preview and you will see the "true" chosen color.
277381
on some machines, the transparency doesn't work with the background-color\ntry it with just background.\n\nbackground: transparent;
174969
It is displayed in the status bar. Unfortunately, status bar is disabled by default.\nEnable it from folder options menu and mark "Apply to all folders"
1009237
sounds like you have your Auto-indent turned on... check your settings... auto-indent will wrap a long line like in an outline.. and indent it instead of going to the left margin.\n\ncheck your document type settings... formal, casual.. etc.. some of them have imbedded Style formats.
505781
Sub ChooseLastRow()\n\nRange("A1").Activate\nDo until activecell.value = ""\nActivecell.offset(1, 0).activate\nLoop\nactivecell.offset(-1, 0).EntireRow.select\n\nEnd Sub\n\n\nDo what ivpjennings suggested. MUCH more elegant. Completely forgot about that!\n\nBe careful with the xlLastCell. There's a bug in Excel. If you are working with your data and you delete a few rows, the xlLastCell will still be the last row of the original data set, not the updated last row after the deletions. Only after saving the file, will xlLastCell return the true correct last row.
131728
There are several ways to go about this, depending on how you have already entered data and what exactly you want it to look like.\n\nDid you already enter data into Excel?  Is it in the format: 9'3", 9'4", etc.?\n\nIs this data entered along a row (across) or a column (vertical), or some other layout?\n\nDo you want Excel to show the data in that same format (i.e. 9'3") or do you want it to say something like 9.25 ft?\n\nAny oher specific information I should know about what you're trying to do?  This way I can give you a useful answer.
249473
I've done this before. I have the spreadsheet at work, and I'll post an answer for you tomorrow. It fills in the right color for you even if you insert lines.\n\nOK. Here you go...\n\nOpen your spreadsheet and select the entire spreadsheet by clicking on the gray box between the A column and the 1 row in the top left-hand corner. Open the Format menu and select Conditional Formatting. Under Condition 1, select Formula Is and type "=MOD(ROW(),2)=0" (without the quote marks) into the empty box next to that. Click on the Format button and choose the formatting options that you want for your green rows. You can choose a color on the Patterns tab. Click OK and OK again. Now all of the even numbered rows should be green (or whatever color you chose). Email me if you're not sure what to do.
1077362
Use the "fill".  So highlight the cell then use the brush to fill in the color that you want.  It should work!
489379
All that usually means is that you have entered a number value, and the column width is too small for Excel to display it.\nIncrease the column width and the spreadsheet will display your numerical value properly.
431572
. Make use of white space \n\nWhite space is the blank area that surrounds the data. Strangely, having white space surrounding your data makes your data appear more prominent on the page. \n\nWhether reading the spreadsheet on screen or printing it out, good use of white space should make your spreadsheet easier to look at and reduce eye-strain. \n\n2. Add borders where needed \n\nBorders on a spreadsheet, just like borders between countries define the sections of information that belong together. It makes it much easier to see at a glance all relevant information. For example a monthly budget may be broken up with borders around each week. That way you can see the budget for the month over all, but as each week has borders around it, you can also easily see what's happening on a weekly basis. \n\n3. Pick a font and stick with it \n\nThere's nothing worse than opening a spreadsheet and finding a hodge-podge of fonts thrown together for no particular reason. It looks unprofessional and can be quite hard to read. Pick one simple font to work with - preferably a common font that will be on any pc the spreadsheet is used on (eg Arial, Century Gothic or Times New Roman). Its also a good idea to choose san serif fonts (eg Arial) over serif fonts (Times New Roman) as they are easier to read. If your spreadsheet is for work, find out what the company preferred font is and use that exclusively. \n\nOnce you've picked your font, feel free to change the colour and size as necessary for emphasis. Using bold for headings and italics to highlight is a good idea - but don't go overboard. \n\n4. Size 8 font isn't a good plan \n\nThe smaller the font, the harder it is to read. While size 8 fonts might look just adorable, they're a nightmare to read for most people - even more so for those with eye problems. This is particularly important to keep in mind if you aren't the only person using or viewing the spreadsheet. Size 10 or even size 12 are much more user friendly (although perhaps not as cute!). \n\n5. Use the correct cell format \n\nCorrect cell formats can save a lot of time and effort. If you are planning on using a column for dates - select all the cells below the heading and format the cells as dates. Excel will then recognise anything you put in those cells as a date. So if you want the format to be 12th December 2003, all you'll need to type in those cells is 12/12/2003 - a huge time saver. \n\n. Colours are great for emphasis \n\nColoured Backgrounds work well with borders to distinguish headings from data, different types of sub-totals and totals, months, etc. Use caution, however, when choosing your colours - using a combination of a lime green background for headings with purple writing and eye popping red backgrounds for your data may not be the best combination. \n\nGenerally, if you are going to make use of any dark colours, they should only be used for headings and you should always use a pale colour for text on dark colours - white and pale grey are good for this purpose. \n\nAny colour used as a background for your data should preferably be a pale shade. \nUse common sense when choosing your colour palette - bad choices can make your spreadsheet down-right painful to look at. If you find you get a headache every time you open your spreadsheet, think about toning down your colours. \n\n7. Charts are a great addition to your spreadsheet \n\nManagement love charts! Why? Because they don't have to wade through oceans of data to get the information they need. At a glance they can see whether profits have risen or fallen. Busy people are far more likely to look at a chart than they are to read rows and rows of data. So, add a chart to your spreadsheet - your boss will love you for it! \n\n8. Think inside the box - Use more than one worksheet \n\nSpreadsheets are basically boxes that are either printed on box shaped paper, or viewed on a box shaped monitor. Try to keep this in mind when designi
661261
You could use conditional formatting on the cells where you are entering your data.  But you actually don't need to do conditional formatting, it's just that you can get smoother more interesting effects if you do.  An easier way might be a simple formula.\n\nIt sounds like you are entering data that uses Case numbers, but if you have already entered a case, you don't want to do it again.  Obviously you could just search the case number column to see if it already exists and if so, then skip entering it.  But a more automated way would be easier.\n\nThe essence of what you need to do is use a formula to tell you if what you just entered already exists in the rows above. (To use your example, does case 24 exist already in the rows above A27?)\n\nYou could insert a (temporary) column to the left of what you are typing in.  In that column you would enter a formula to count the number of instances where the case number you just entered already exists above.  Usually the result would be 1, sometimes 2.\n\nLets say you are on row 27 and your case numbers are in column B, and your counting column is column A.  Lets assume your data starts on row 2 at the top of the spreadsheet.  Your formula for cell A27 would be:\n=IF(COUNTIF($B$2:B27,B27)>1, "Exists Already!", "")\n\nNotice the $ signs in the Countif formula.  The formula range will adjust as appropriately as you copy it around.  You want to get this formula on every line next to every case number so that it can alert you if it seen there is more than once instance.\n\n(Actually the Data Validation mentioned below is a better solution because it will prohibit you from entering the data.  But it's all the same principle. Just more elegant because you don't need to insert a new column.)