1 Resources for

last cell

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

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

Additional Resources

Excel Help: Im trying to auto fill a formula that gathers info from other cells, but is not a fixed cell. I need it to increase by eight cell numbers at a time. like here=CELL("contents",Sheet1!$E6)=CELL("contents",Sheet1!$E14)=CELL("contents",Sheet1!$E22)=CELL("contents",Sheet1!$E30)=CELL("contents",Sheet1!$E38)but when I auto fill comes out like this=CELL("contents",Sheet1!$E6)=CELL("contents",Sheet1!$E14)=CELL("contents",Sheet1!$E22)=CELL("contents",Sheet1!$E30)=CELL("contents",Sheet1!$E38)=CELL("contents",Sheet1!$E11)=CELL("contents",Sheet1!$E19)=CELL("contents",Sheet1!$E27)=CELL("contents",Sheet1!$E35)=CELL("contents",Sheet1!$E43)=CELL("contents",Sheet1!$E16)=CELL("contents",Sheet1!$E24)=CELL("contents",Sheet1!$E32)=CELL("contents",Sheet1!$E40)=CELL("contents",Sheet1!$E48)=CELL("contents",Sheet1!$E21)=CELL("contents",Sheet1!$E29)any help would be appreciated.; Tags: Processors, Microsoft Excel, Cell; Discussion threads 2008-10-31
Excel Formula help: Excel Help.Im trying to auto fill a formula that gathers info from other cells, but is not a fixed cell. I need it to increase by eight cell numbers at a time. like here=CELL("contents",Sheet1!$E6)=CELL("contents",Sheet1!$E14)=CELL("contents",Sheet1!$E22)=CELL("contents",Sheet1!$E30)=CELL("contents",Sheet1!$E38)but when I auto fill comes out like this=CELL("contents",Sheet1!$E6)=CELL("contents",Sheet1!$E14)=CELL("contents",Sheet1!$E22)=CELL("contents",Sheet1!$E30)=CELL("contents",Sheet1!$E38)=CELL("contents",Sheet1!$E11)=CELL("contents",Sheet1!$E19)=CELL("contents",Sheet1!$E27)=CELL("contents",Sheet1!$E35)=CELL("contents",Sheet1!$E43)=CELL("contents",Sheet1!$E16)=CELL("contents",Sheet1!$E24)=CELL("contents",Sheet1!$E32)=CELL("contents",Sheet1!$E40)=CELL("contents",Sheet1!$E48)=CELL("contents",Sheet1!$E21)=CELL("contents",Sheet1!$E29)any help would be appreciated. Thanks; Tags: Processors, Microsoft Excel, Cell; Discussion threads 2008-11-03
Truncating a cell: I want to be able to reference a cell that is formatted with a four digit year into another cell, but have the destination cell truncate the value so only the last two digits of the year show.For example, cell A1 is 2008, and I’m referencing that value in cell...; Tags: cell, E47; Discussion threads 2008-06-25
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

Using thew value of one Excel Formula in another cell: In Cell B2 I need to enter # of hours workedCell B3 is the formula =B2*28.084Cell B13 is the problem cell. It uses the following Nested IF formula:Here is my issue.In my worksheet I need to enter # of hours worked in cell B2Cell B3 is the formula =B2*28.084This part...; Tags: Microsoft Excel, Cell, Cell B13, cell; Discussion threads 2008-09-06
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
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
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
Want to Receive Cell Phone Calls On Desktop/Laptop: I am having hell load of calls on the cell phone from the vendors all the day long.it is really not comfortable to hold the Cell phone all the time, and I hope it is damaging my head aswell.We are 6 people working in this department, and looking for a...; Tags: Cellular phones, fdeeez@..., cell phone, telephone, laptop computer, desktop; Discussion threads 2007-04-22
Excel Macro script for up/down one cell movements: HELP! I am recording a macro but cannot figure out how to move up&down one cell without the macro recording it as moving to a set cell ref.need the exact script code that just moves up one or down one cell. Arrow key movement only indicates a cell ref...; Tags: Microsoft Excel, Microsoft Site, cell; Discussion threads 2008-06-25
Cell Values: I am working on a quote form and have a table on the form with column headings 1,2,3,4,5 and row titles of a,b,c,d. As the user selects a $ amount in the table, I need to populate the $ amount in another cell. Can someone start me in...; Tags: cell, Value at Risk, karabryan@..., software; Q&A 2006-01-30
Excel ~ Special Cell Formatting: Does anyone know how to format maybe even build a specialized format to apply to a specific Cell. For instance, I want a specific cell (A1) to capitalize anything that is entered into it (cell A1). (I don't want one cell to show the contents of another cell.)...; Tags: Microsoft Excel, patricia.lynn@..., cell, Cell; Discussion threads 2007-10-10
Excel Formula help: Excel Help Im trying to auto fill a formula that gathers info from other cells, but is not a fixed cell. I need it to increase by eight cell numbers at a time. like here=CELL("contents",Sheet1!$E6)=CELL("contents",Sheet1!$E14)=CELL("contents",Sheet1!$E22)=CELL("contents",Sheet1!$E30)=CELL("contents",Sheet1!$E38)but when I auto fill comes out like this=CELL("contents",Sheet1!$E6)=CELL("contents",Sheet1!$E14)=CELL("contents",Sheet1!$E22)=CELL("contents",Sheet1!$E30)=CELL("contents",Sheet1!$E38)=CELL("contents",Sheet1!$E11)=CELL("contents",Sheet1!$E19)=CELL("contents",Sheet1!$E27)=CELL("contents",Sheet1!$E35)=CELL("contents",Sheet1!$E43)=CELL("contents",Sheet1!$E16)=CELL("contents",Sheet1!$E24)=CELL("contents",Sheet1!$E32)=CELL("contents",Sheet1!$E40)=CELL("contents",Sheet1!$E48)=CELL("contents",Sheet1!$E21)=CELL("contents",Sheet1!$E29)any help would be appreciated.WeirdWeird one this, I...; Tags: Processors, Microsoft Excel, Cell; Discussion threads 2008-11-03
Excel: text and value in cell to be then used in a formula?: I'm trying to use a formula and text combined cell in another formula as a reference, but am getting an error. Example, A1referenced cell: =ROUND(Inputs!I56,2)&" kWh"A2reference cell: =180000*A1/3and I get a #VALUE! error in A2... help?When you add text....When you add text to the contents of cell A1, you turn...; Tags: Microsoft Excel, cell; Discussion threads 2008-06-25
Code to delete graphics in a Word label: I am using a 12 cell label for mailing labels. Each of the 6 standard cells for the label template was split and has a graphic with our address/logo in the top cell and the recipient address is placed in a field in the bottom cell. I want...; Tags: Microsoft Word, dtenbrink@..., cell, graphics; Discussion threads 2007-10-05
Excel cell comment: Hi all,I am using VB6 to parse through an Excel spreadsheet.I can get the cell data without any problems.Does anybody know the syntax / commands to extract the cell comments?Thanks for any help.John; Tags: Microsoft Office, cell comment, Microsoft Excel; Discussion threads 2008-02-12
Use Outlook to send e-mail to a cell phone: Outlook is flexible enough to send e-mail to cell phones. You just need the cell phone's 10-digit number, the carrier's domain, and a cell phone that supports SMS. by Susan Harkins; Tags: Microsoft Outlook, Phone, Cell Phone, E-mail, Telecom & Utilities, Cellular Phones, Consumer Electronics, Personal Technology, Susan Harkins; Blog posts 2008-06-30

<< Previous
page 1 of 1
Next >>

Windows XP vs. Mac OS X: This presentation, entitled Standardizing on Windows XP Instead of MAC OS X, provides a pre-packaged option for defending Windows XP against MAC OS X. ...; Buy Now

Windows XP Network Troubleshooting Power Checklist: Windows XP is pretty easy to connect to a network. Sometimes, however, things just go awry. That's when you need a strategy. This power checklist walks you through how to figure out what's wrong with Windows XP networking and how to get it fixed.; Buy Now

last cell

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Additional Resources

Storage Virtualization