Free Microsoft Excel 2013 Quick Reference

How do I delete items out of my "recent documents" list?

How do I delete items out of my "recent documents" list?


How do I delete a series of check boxes that have already been created? Up
until now the only way I think to get rid of them is by selecting one and
then cutting it and then moving on to the next one. Since I have over a
hundred this is tedious. I have tried deleting the column in which they
appear with no luck. The column is deleted but the check boxes remain.

A co-worker recorded a print macro in one of my workbooks. It is of no value
(the workbook is only 3 pages and there is no need for a macro). Besides,
the macro won't run because of the security setting on the workstation. I am
trying to delete the macro because the dialogue box that explains why it
can't run is annoying. I follow the Help directions and go to
Tools/macro/macros/this workbook and highlight the macro but the only
available buttons are "Run", "Cancel" and "Step into". The "Delete" button
is greyed out. How do I delete this thing?

TIA,
MG

A co-worker recorded a print macro in one of my workbooks. It is of no value
(the workbook is only 3 pages and there is no need for a macro). Besides,
the macro won't run because of the security setting on the workstation. I am
trying to delete the macro because the dialogue box that explains why it
can't run is annoying. I follow the Help directions and go to
Tools/macro/macros/this workbook and highlight the macro but the only
available buttons are "Run", "Cancel" and "Step into". The "Delete" button
is greyed out. How do I delete this thing?

TIA,
MG

How do I delete the blank lines at the bottom of an Excel worksheet, so that
that the drag bar on the right is proportional to the populated portion of
the worksheet?

How do I change the order of items in a legend for an Excel chart?

How do I delete 100 account numbers from a spreadsheet colume were it only
leaves the last 5 digits of all the accounts with out having to physicaly
delete each account manually

how do I delete thousands of pictures that are somehow embedded in excel?
They are just simple dots, but there are over 6000 and growing rapidly make
the file size huge.

Up until yesterday, the labels at the top of my spreadsheets were letters
(A,B,C...). Today they are numbers (1,2,3...). How do I change them back,
and what might have happened to cause this?

Anna-Maria

Hello All -

If I have a column with a long list of file names that end with .tif how do I delete the .tif part with a macro.

Right now, I have the ability to add .tif

Dim cell As Range

For Each cell In Selection
If cell.Value <> "" Then
cell.Value = cell.Value & ".tif"
End If
Next cell
End Sub
However, I am having trouble deleting it.

Example:

Column A

filename.tif
another.tif
here.tif
there.tif

I need all the .tif deleted.... I know that I can do a text to column and delimited by ".", however, I would rather have a macro to do the work instead.

Hope you can help. Thanks

for some reason when i export my contacts to a csv the email addresses are
not separted by a comma but by a semicolon.

i used the formula that seperates first name and last name together into two
seperate columns searching for semicolon instead of space.

the result is that a proportion of the email addresses are suffixed by a
semicolon.

how do i delete the semicolon?

thanks

Hi Everyone,

I want to help clean up this awesome site by deleting my solved posts, how do I delete it?

Thanks

Francis

I have password protection user form , how do i set the range of the IF statement that checks whether the password is correct.

I want to have a worksheet that general users can access to change their passwords without going through my current IF statement in the coding which i'm finding a very long way of doing it. So i want to have a 'Passwords' Worksheet and have all the passwords accepted into that sheet. Linking to the user form, with the IF statement for the text box for the passwords to be entered.

The passwords are only 4 digit numbers not requiring a user name.

Could someone kindly help me with this problem.

Two Columns, Column 1 is filled with references (in text), and column 2 with descriptions, how do I count the no. of different descriptions in Column B of the same reference from Column A irrelevant of it being in capitals:

eg.

1 2
A bag
A bag
B Piano
A BAG
B Jumper
A car
B piano

A would be 2 (i.e. 2 different descriptions Bag and Car)
B would be 2 (i.e. 2 difference descriptions Piano and Jumper)

Many thanks

I've created an Accounts Payable spreadsheet, and I need the names of my
columns (Payee, Invoice Date, Invoice Number, etc.) to print at the top of
each page. It's such a pain to wait until I've finished the sheet, and then
go to where the page breaks are and insert a new row, and then paste the
column names in it. If I need to go back and revise any part of the
spreadsheet, then I have to delete and recreate in another place those rows
that I've added.

Is there a way to set print options so that the names of my columns can
print at the top of each page? (Not the A, B, C, etc.)

I have a worksheet in Excel which I do scheduling with. I keep getting the
Header printed out on it, and then as a page 2. I don't see how to delete the
page two on the worksheet as it doesn't show. But will print. How do I delete
that second page in the worksheet? Am using Microsoft Office Pro 2003.

I have a huge spreadsheet that requires me to zoom out to see more than a
single column. My drop down lists now appear as tiny text. How can I make
my drop downs appear bigger.

I am trying to delete an already previously saved Excel spreadsheet that is
no longer needed. When I go to the Office button at the top left corner of
Excel & go to recent document & then highlight the Excel spreadsheet, I no
longer need, it does not give me the choice to do what I want to do. How do I
delete an already previously saved Excel spreadsheet?

Office 2007, Complete dunce
I have a large 3 col Excel spreadsheet where certain cells in col A are
empty.
How do I delete every row where the cell in Col A is empty?
Should the answer require code or a macro to be entered, please tell me FULL
details of EVERY keystroke in the answer.

Sometimes when I create an Excel document in Excel 2007, it is somehow saved
into the "recent items" category, and sometimes in the regular documents
file. Why does this happen, and how can I move docs out of the recent items
folder?

Was working in a spreadsheet when it created 2000+ pages. How do I delete
these add on pages so that I do not have to worry about accidentally printing
them?

Hi,

I am not sure how to ask this, so here it goes...

How do I maintain the integrity of an array in a formula in a worksheet?
For example, from a formula that was helped with here earlier...

This keeps track on everything listed in the columns specified that is older than 15 days (thanks again Bryan).

Since this is on a worksheet that I keep track on Accounts Receivable, I delete rows at least everyother day. When deleting rows, the last row specified gets smaller.
Exp... I delete 5 rows...,
the "(I5:I1000<Today() -15)" shrinks to "(I5:I995<Today()-15)".

Is there a way I can specify the formula not to change and remain the specifie number of row without shrinking.

Thanks

How do I determine what version of ecxel I am running on my pc. I have
Windows XP Home edition.

How do I delete duplicates from a spreadsheet and keep only the unique
records? If I have the name "Smith, 123 Lane, City" listed 2 times in a
spreadsheet, I want to delete both of the records and not keep either record.

i have a main emailing list that i keep in xl and sned out my newsletter to
this list each month . however i have collected my unsubscribe list on
another spreadsheet. How do i now remove the unsubscribes from the main list
without having to go through it manually.

thank you