Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- Excel Question
- Hi --If I want to sum a row of numbers ONLY IF there are NO blank cells in the row (and if there are any blank cells then the cell where the sum would appear would instead return a message like "BLANK CELL FOUND", then how do I do this?...
- Tags: B2:E2, BLANK CELL FOUND, cell, Excel Question, johnshenyang@..., Microsoft Excel
- Q&A 2005-10-14
- Excel Formula Question
- Hi --If I want to sum a row of numbers ONLY IF there are NO blank cells in the row (and if there are any blank cells then the cell where the sum would appear would instead return a message like "BLANK CELL FOUND", then how do I do this?...
- Tags: B2:E2, BLANK CELL FOUND, cell, johnshenyang@..., Microsoft Excel, software
- Q&A 2005-10-14
- Nested If? Vlookup? Please help if you can.
- Please bare with this post I believe I've spelled it out in relatively easy to understand scenarios. It's the only way I knew to ask the questions I have. I am working on a spreadsheet for work. I need to develop a few formulas. Following are...
- Tags: Rosstamon, cell, L21, O21, Cells I21
- Discussion threads 2007-09-12
- Excel 2003 Wrap text problem
- Hi,I am having a wrap text problem. I have created a costing spread sheet. In column A (width 75.00 530 pixels),wrap text is activated, using true type arial font size 11. When text is written up to cell width limit with the last character of the last word even in...
- Tags: Microsoft Excel, Microsoft Excel 2003, svenjaman@..., cell
- Discussion threads 2007-07-30
- Excel formula
- I am trying to write an "if blank" formula in ExcelI have the following formula working - =if(blank(D6),0,E5+D6)this checks D6 and if blank, enters 0. If not blank, E5 is added to D6.I need to check that D6 and C6 are both blank.Any suggestions.Thanks=if(blank(D6) & blank (C6),0,E5 + D6)I...
- Tags: 0,E5 D6, C6, D6, hduff@..., Microsoft Excel, software
- Q&A 2005-10-05
- Autofill a spreadsheet
- I have a spreadsheet I send out as a letter and whos reference number ascends chronologically. This reference number is shown on the form in a cell, say E4. I want to be able to type in the reference number on a blank template of the letter and...
- Tags: PRODUCTIVITY, jason-debaugh@..., reference number, spreadsheet
- Discussion threads 2007-06-16
- Reset the last cell of your Excel worksheet
- Excel often will default to the last cell you've entered data into—even if you've wiped it out. Mary Ann Richardson shows how to create a macro that will reset the unwanted cell. Your job involves adding data to the end of a very large Excel worksheet. To get...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, cell, last cell, Microsoft Office Suite Excel Tips Newsletter, Office Suites, Software
- Technical articles 2006-11-21
- Any Excel Gurus Out There?
- hello all, is it possible to reference data from a merged cell into a single cell? and if so how? whenever i try it i get #VALUE in the single cell. any help with this would be greatly appreciatedre: merged cell referenceIf you're getting #value in the single cell, you...
- Tags: Microsoft Excel, hull_max@..., cell, single cell, merged cell
- Discussion threads 2007-07-11
- Quickly convert text values to numbers with Excel's Paste Special
- After copying data from an Access table, you notice that you cannot perform any calculations on what you thought were number fields. Instead of numbers, the imported values behave as text. By using Excel's Paste Special feature, you can quickly convert those values to numbers. Follow these steps:1. ...
- Tags: tip, Microsoft Office, Excel
- Blog posts 2007-07-24
- How do i highlight the active cell in Excel?
- Is there a way to highlight the active cell in excel, so that when you click on a cell it shows up in yellow or some other color? I'm not referring to the option to use the paint bucket to fill the active cell. I want the highlight to disappear...
- Tags: freakyj92@..., Microsoft Excel, active cell, cell
- Discussion threads 2007-10-18
- Sorting for multiple data in Excel
- I have a large sheet of mailing data for doing a mail merge (>17,000 lines) but I would like to sort these many lines to show me only 125 zip codes among all the lines of data and zip codes. Each line of data has a column with it's...
- Tags: cell, empty cell, Microsoft Excel, software, swdrake1@..., ZIP code
- Q&A 2005-09-14
- 10 keyboard shortcuts for speeding your work with Excel data
- Which Next Cell?Nice collection of keyboard shortcuts, but the first one input and move to next cell has two shortcuts, depending on the direction of input:Type + Enter takes you to the next cell DOWN;Type + Tab takes you to the next cell RIGHT.When inputting across, using TAB to...
- Tags: Microsoft Excel, keyboard, MJGunther, cell, keyboard shortcut
- Discussion threads 2007-10-10
- Excel adding information from one cell to another cell
- I have three different cells with words in them and i need to add them all into one cell. Is there a formula for this?examplecell a1 says happya2 sada3 madi want my end product to becell a1 saying happy sad mad thanks.
- Tags: Microsoft Excel, happy_murray@..., cell
- Discussion threads 2007-05-14
- Locate any Cell Phone/Cell Phone Number!
- Because of the demand of Cell-phone, antennas are everywhere in our society. After few days of research, I found out we are not only can be monitor our everyday lives by Credit Card but also with our Cell-Phone (# of People owned a cell-phone is much higher than Credit Card.)...
- Tags: Cell, cell phone, GPS, mak1515@..., networking, telephone, wireless
- Discussion threads 2006-09-14
- Hide Excel's error values in your printout
- If you print out a spreadsheet only to find that it contains error codes you would prefer to keep hidden, there's a way to avoid this from happening in the future. With this Excel tip from Mary Ann Richardson, learn how to keep the errors where they belong—on the screen,...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, PRODUCTIVITY, Microsoft Office Suite Excel Tips Newsletter, Spreadsheet, Error, Office Suites, Software
- Technical articles 2006-06-26
- crate xl range name from a variable
- My macro copies a template worksheet, renames it with user prompted msgbox value with leading zeroes. The value "newname" becomes the sheet name as well as the contents of cell D3, E3 will contain a balance. I want to list the various D3's and E3's on Consolidated sheet so I...
- Tags: SELECT
- Q&A 2006-03-30
- Creating a dropdown list that coresponds to different cells
- I would like to know how to create a drop down list for a specified set of values, I want these values to correspond to a different value for exampleRough Concrete corresponds to 0.8so when i select the name such as rough concrete the value 0.8 appears in a cell...
- Tags: Johnmotson@..., cell
- Discussion threads 2007-11-12
- Excel 2003 Hyperlink Issue
- I'm trying to hyperlink a single work in a sentence that is all within one cell. So far, I'm only able to link to the entire cell/sentence. Example: Can techrepublic answer this question? With techrepublic underlined/highlighted as the hyperlink. All within a single cell. ...
- Tags: cell, matthewhaggerty@..., windows, 2003, excel, hyperlink, Microsoft Excel
- Discussion threads 2007-01-31
- << Previous
- page 1 of 1
- Next >>
