What does xfd mean in excel

The LastCell should be normal when you re-open. If you are absolutely sure that DE is the last cell will data in it, walk through these steps,. It might seem like a lot, but it takes a lot more time to type it than it does to actually do it. Thanks guys for all your feedback. Unfortunately any solution involving deleting rows simply takes too long hours. I tried copy and pasting only the used cells but the problem persists. I've resorted to bringing my personal laptop to work with office and having no issues.

I'm currently pleading with my IT guys to re-install Office on my work machine. The method Biff suggested does not take "hours" to delete all the unwanted rows. And, just because you fix the problem, does not mean you can do the same thing that caused it to begin with and it won't happen again.

XL is not unique in that regard. But I do whole heartedly agree with you about the user-hostility being exhibited in each new version of Excel. I have to work with over users, having all versions of Excel so I have 6 versions on my computer, but given the choice, I use only XL every time.

Seems a shame that we have to "beg" our IT Depts to do the things we want It's stupid how some Companies put the entire company computer equipment budget under the IT director Choose where you want to search below Search Search the Community. Hi, I'm working with a fairly moderate data set with actual last used cell at DE This thread is locked.

You can follow the question or vote as helpful, but you cannot reply to this thread. Each cell can contain either data numeric or text or a formula. Cells are arranged in rows and columns in the workbook. Rows are labelled with numbers going from 1 at the very top to 1,, at the very bottom. Columns are labelled with letters going left to right starting with A and going to XFD. The intersection of a column and a row is a cell and the address of this cell is given by its column letter and row number.

One cell in the worksheet is called the active cell. This means you can edit its contents or enter new data or formula into the cell by typing on your keyboard. You can identify the active cell in the worksheet by:. By default a new Excel workbook contains 3 worksheets, but you can change the default number of sheets in a new workbook to any number you like.

Only one worksheet is visible at a time, this is called the active worksheet. The default names Excel gives worksheets are pretty generic Sheet1 , Sheet2 , Sheet3 etc… but you can change them to something more meaningful, so if your sheet contains sales data you might name it Sales Data.

You can also delete a worksheet from the Home tab in the Cells section by going to Delete then Delete Sheet. You can also insert a worksheet from the Home tab in the Cells section by going to Insert then Insert Sheet. Left click on the sheet which you want to move, hold the mouse button down and drag the sheet to the desired location. A small sheet icon will display on your cursor while you are dragging the sheet to its new location. For more options like moving a sheet to another workbook or making a copy of the sheet, use the Move or Copy command from the right click menu.

Worksheet Area. By John MacDougall. Notify me of new comments via email. Cancel Report. Create a new account. Log In. Know what is XFD? Got another good explanation for XFD? Don't keep it to yourself! Add it HERE! Still can't find the acronym definition you were looking for?

Use our Power Search technology to look for more unique definitions from across the web! Search the web. Citation Use the citation options below to add these abbreviations to your bibliography.

Powered by CITE.