Free Microsoft Excel 2013 Quick Reference

how do I prevent sharing of an Excel 2000 file?

If I have an Excel 2000 file with data that I only want the recepient to view, how do I establish permissions for the file such that no one but the recepient can open/view the file even if the file gets sent to someone else? I know I can password protect the sheet/workbook, but the recepient can always just share the password so that's no good.

Thanks.


how do i put items on an excel chart in ABC order?

How do I put this into an excel formula ?

If this "MID(N3;6;3)" equals "OLA" then do this "MID(N3;6;3)&LEFT(N3;3)"

otherwise

Y3&MID(N3;6;3)

Thank you in advance.

How do I close a link in Excel 2000?

Can someone tell me: what do I need to create an Excel format file?

I want to use Macromedia Flash to create the file.
Through another 3rd party tool: I can use Flash to create text files and possibly more advanced file formats.

Are there some basic constructs that if I make the file be... then I can simply make an Excel file?

Apologies if this is the wrong group to post in - I couldn't find anything more relevant on this forum.

Thanks.

OM

In Excel 2003 when I drag a cell down filling a bunch of cells with its contents, I end up with an annoying flag right in the middle of the area that I'm working and the only why I've found to get rid of it is to hit sort. This is a very unsatisfactory temporary solution. How do I get rid of this drag fill in flag?
Rohed

In Excel 2003, I can create an Excel list by selecting the command "List"
under the "Data" menu. I do not find the same selection in Excel 2000. How
can I create a list using Excel 2000 as I use Excel 2000 at home.
When I open the list I created in Excel 2003 at work in Excel 2000, all the
list features disappear, all I can see a simple straightforward spreadsheet.
I wish I know how to create the list in Excel 2000 so that I can do
filtering, etc...
Thanks for your help.

In Excel 2003, I can create an Excel list by selecting the command "List"
under the "Data" menu. I do not find the same selection in Excel 2000. How
can I create a list using Excel 2000 as I use Excel 2000 at home.
When I open the list I created in Excel 2003 at work in Excel 2000, all the
list features disappear, all I can see a simple straightforward spreadsheet.
I wish I know how to create the list in Excel 2000 so that I can do
filtering, etc...
Thanks for your help.

How do I prevent saving an excel file if cells are blank?

I have multiple pages on multiple sheets on excel. Pagination is set up
under Custom Footers. An extra page prints at the end of each "sheet", thus
throwing off the pagination of the sheets that follow. How do I print only
those pages that contain information?

How do I import Names of Windows files or folders into an Excel Spread sheet?

Please e-mail me at

How do I import Names of Windows files or folders into an Excel Spread sheet?

Please e-mail me at solrac1956@msn.com

I have multiple pages on multiple sheets on excel. Pagination is set up
under Custom Footers. An extra page prints at the end of each "sheet", thus
throwing off the pagination of the sheets that follow. How do I print only
those pages that contain information?

I want to use a column of information from an excel file and make file labels
with that information. How do I do this?

I have a black box that shows up when I try to print an excel worksheet that
was sent over as an attachment. How do I get rid of it?

In Excel, how do I prevent a row from moving, like a subheader that I want to
stay always visible at the top of my document?

I wnat to print picture of what the screen looks like after you click oin
'file', etc. How do I capture that in an excel file?

How do I find 1 of the 24 clipboards that excel says I have?

I am trying to send a single row of data to an access database table.
Column in the spreasheet represent a column in the database table.

I want to append new records to the database and send backa reference.

how do i do this.

I am using Excel, and every time I enter 2/1 in the spreadsheet - it corrects
it to Feb-1. How do I prevent it from doing this?

I have many sheets in an excell spreadsheet that I need to sort in
alphabetical order how do I do it?

When I try to print an Excel worksheet, large block letters overprint on the
text. How do I get rid of them?
Thanks,
Roberta

Hello all,

This is probably a simple question, but how do I put a button on a sheet or put checkboxes for a boolean portion of a column? How do I then react to the button click? We upgraded to 2007 and I'm trying to learn where stuff is on the ribbon. Thanks in advance for any ideas and/or suggestions!

i took my master customer list which was generated by my POS written in Access, and singled out the column that had the phone numbers in it. i am trying to import this data into a program called SMSgee. it seems to support xml files and csv files.. i already save this data as a csv file, but am having trouble getting the program to read it..

my current plan is to take the phone # out which are in column "B" and start at row 2..then i'd like to pull the phone numbers out of every 5 rows..2, 7, 12 etc..and make a CSV file and try to get the SMSgee program to take that..

how do i do this? also how do i eliminate all the columns i don't need?

I have a spreadsheet where a default in a field is changed by a double
click. A second double click will return the field to the default.

I only need the field to show the 'default' or the 'alternate' entry.
No other entry is needed.

How do I prevent an operator from entering text?

Thanks,

Robin Chapple