Is there a way in Excel to fill every second row of a long spreadsheet with colour at the touch of a button?
481237
Conditional formatting. \nSelect the columns/areas\nGo to: Format, Conditional formatting. \nSelect 'Formula is' in first drop down, in data entry, type in =MOD(ROW(),2)=1\nclick format\nselect patterns\nselect a background color\nclick ok\nclick ok\n\nTo get it in a button, start recording a macro, do the steps listed above, add a button from the forms toolbar, link the button to the macro you just recorded.
1005206
the same way you do it with excel...
326425
Make sure you have a color printer defined and set as default printer in excel. Wierd, I know!
321309
Use a table.  The best way to start is probably to draw it on paper so that you can see it while you're typing it in.  Remember that it starts with a row, then you add cell by cell going left to right.  Each time you add a cell, alternate the bgcolor of the cell \nEx:\n<TABLE>\n<TR>\n<TD bgcolor="black" width="10"> </TD>\n<TD bgcolor="white" width="10"> </TD>\n<TD bgcolor="black" width="10"> </TD>\n</TR>\n<TR>\n<TD bgcolor="white" width="10"> </TD>\n<TD bgcolor="black" width="10"> </TD>\n<TD bgcolor="white" width="10"> </TD>\n</TR>\n</TABLE>\n\nThis is just an example, but you should be able to see how to follow...\nP.S. - It's not showing up here, but you need to add ampersand nbsp ; (the escape sequence for a non-breaking whitespace) inside each of your table cells
775038
Nope, sorry.  What you're describing is a query.  Only Access can do that.  It's a pretty simple one, and exporting back and forth between Access and Excel is pretty easy.  If you want some help in how to do it, send me a message.
41383
Here, http://www.functionx.com/excel/articles/radiobuttons.htm is a tutorial on how to create exactly what you want.  For the record what you are trying to do is create something called "radio buttons" (don't ask me why they called them that).\n\nThe basic steps are to Open Excel and go to View > Toolbars > Forms and select Forms.  That's where I'll stop as the tutorial explains it much better than I could here.
135478
This is cool.  Use the Print Area function.  From File menu, choose Print Area.  Choose to clear it, first of all.  Then highlight all the portions of your spreadsheet that you wish to print.  \n\nYou can highlight sections that are not next to each other (noncontiguous) by using the CTRL key while blocking w/the mouse.  So, for example, use the mouse to highlight columns A and B.  Let go of the mouse button and see that those areas are highlighted. Without doing anything more (don't click anywhere, don't use an arrow key, etc.), press down the CTRL key and then click on column D. You will then see that columns A,B and D are highlighted (but not C).  You can choose your own print area in this fashion.  \n\nAfter you've gotten your print area highlighted, go to the File menu, choose Print Area, and choose Set Print Area.  Now only the things that were highlighted are going to print.  You can see this on the print preview screen. \n\nEnjoy!
817438
1. Select the cells you want to include in  a range.\n2. Click on the name box.\n3. Type the name for the range.\nthat's it.\n\nClicking the drop down button on the name box will list all the range names that has been created.
133790
use chart wizard in Excel ... 2nd button to the left of zoom% box on toolbar.
1156460
You can select the column you want and copy it. Then go to the target (where you want to make it into rows) and select Edit -> Paste Special from the menu bar. In there, make sure you mark the box that says 'Transpose'. Voila!
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.
406314
If you know Java, it is not hard to write code to do such task, it might be tedious though.\nIf you don't, Ms excel could handle the job too with reasonable time and effort.
1171960
That should work by default; the only exception I've ever had is when there are more than 32 references within an individual formula. And even then, color-coded cell references will work for the other formulas in the sheet.\n\nI've never seen the limit written anywhere, just found it by trial and error.
538436
Copy the code here: http://www.ozgrid.com/VBA/Sort.htm and follow the instructions in the middle of the page that begin: "To use this UDF push Alt+F11..."
1156850
Yes, I know alot about Excel, I am the XLMan\n\nsend me your IM so I will add you to my list and start with your questions.\nRead my profile, I can solve this out and teach you, actually I like teaching Excel as well, so don't worry.\n\nBy reading your question I think what you need is to save the date every day in a cell, well this can be done in some tricky macro, (If you are interesting)\n\nXLMan
588082
If your data is spread across many sheets, but the layout of the sheets is the same (i.e. the columns and formatting are all identical), and you want to get all the data on to one sheet, then just copy and paste it together on to one sheet.\n\nWithout knowing more details, there is no quick way to avoid just doing it by hand.
964099
Just go to the Cell that you want the total in.\n\nType +sum(d2..d6) where d2 = your first cell to be added and d6 = your last cell to be added.\n\nYou could also use the AUTOSUM button on the top toolbar.\n\nHighlight the cells you want added and hit the button.\n\nHover your cursor over the buttons till you find it.