Free Microsoft Excel 2013 Quick Reference

How can I print on the front and back of a page in excel?

First and best option, if your printer has duplexing capability, then go to
File|print|Properties and look for the option to print 2-sided.

Print your document. Then flip it upside down and add one blank piece of
paper to the top of the pile. Print the document again, and then sort
through the pages. Note: Make sure your pages are numbered, or your going
to have a real headache on your hands.

"shell369" wrote:

> I need to know how to get two pages in excel to print front and back on one
> sheet.


I have a significant amount of content in excel in this type of format:

NAME ADDRESS CITY ST ZIP COUNTRY PHONE website email

In order to upload to the program that I am using I need to add an asterisk mark to the front and back of each field.

*NAME* *ADDRESS* *CITY* *ST* *ZIP* *COUNTRY* *PHONE* *website* *email*

Any ideas for how I would achieve this without having to manually input the asterisk a thousand times?!

hi,
this is a printer option not an excel option. technically all excel does is
send the data. click the options button in page setup. this will display the
options of your default printer. if your printer has such an option, you can
set it here. if your printer does not have this option, then excel cannot do
what your printer is physically incapable of doing.
regards
FSt1

"Steve H" wrote:

> I have a document in excel which has 2 pages seperated by a page break of
> course. I want to print it so that it comes out as page 1 on the front and
> page 2 on the back without having to print it and refeed it upside down etc.

I have never had a troubleshooting problem, but this one has baffled me. I
have two simple worksheets, and I am having the worst trouble printing each
worksheet front and back (2 sided). I will set the printing options to 2
sided, make sure it's printing the 'entire workbook', and it still comes out
on seperate pages. Any suggestions?

How can I programmatically determine the Amount and MinusValues of a chart
series that has X and Y error bars? I need to change the error bars into
error ellipses but first I need the size of the individual error bars.
The ErrorBar method sets the Amount and MinusValues, but the ErrorBars
property appears to only allow access to what it looks like.

=MID(A1,5,255)
If the result is numeric for sure, you can use
=1*MID(A1,5,255)
or
=MOD(A1,100000)

Bob Umlas
Excel MVP

"MFreeman" <MFreeman@discussions.microsoft.com> wrote in message
news:2D1E0EC5-6E32-46F5-9F1D-79DF3E515DEE@microsoft.com...
> How do I remove the 1st 4 characters of a field in Excel?

Amendment to previous response. the cells have more than 255 characters.
That's the max column width.

"MFreeman" wrote:

> How do I remove the 1st 4 characters of a field in Excel?

how do i show only the last four digits of a credit card number

How do I remove the 1st 4 characters of a field in Excel?

I can not get excel to print on front and back of a page. I tried setting it
to duplex printing but that did not work. If there is not a way to do it
then can I only print odd and even pages. If so then how?

I have a workbook that has 10 data worksheet and from these I create another 10 charts (not embedded, just chart sheetS).

How can I print the charts only with a macro? I have found many examples to print charts embedded in worksheets but none that just prints any chart found in the workbook.

Any ideas?

The macro I've been trying is the following (trying to print a worksheet by matching a string to its name - since "chart" is always included in my chart sheets name)
Sub PrntAll()
Dim match as string
match = "chart"
dim sheet as worksheet

for each sheet in thisworkbook.worksheets

if Instr(1,UCase(sheet.name),ucase(match),1,) > 0 then
sheet.printout copies:=1
end if
next

end sub
I tried playing around with capitals and small letters but it won't work.

I have several worksheets that info sends to the last worksheet for payroll...certain rows from certain worksheets go into this last worksheet....how can I print just the rows that have information on them....is that possible???

Thank you, Capt. P

Worked a treat. Took me some time to sort my queries out but that was good.
Had more problems with the actual input for producing the query but found the
parameters section in excel and managed to setup 3 queries referencing the
same date to pull back the data from 3 different spreadsheets. Worked like a
charm.

Thanks for your help - brilliant.

"Duke Carey" wrote:

> Somebody else will pop in with a formulaic solution, which I think is the
> wrong tool for the task. I'd recommend you use Data->Import External
> Data->New Database Query and let your first sheet act as a database. You can
> set the date criteria in the query and return ALL the entries that match the
> criteria to your spreadsheet. Plus, Excel will remember your query and allow
> you to modify your criteria and update the data.
>
>
>
> "Morgs" wrote:
>
> > Hi, can anyone help please? I'm not sure which function I should be using
> > even!
> >
> > If I have a list of people, address columns, postcode and a date in one
> > sheet so how can i return all the people (and all of their address and
> > postcode too) who are coming on a certain date to a different spreadsheet
> > (not using autofilter). There could be 10's or 100's that will match the
> > date criteria and I want all of them, not just one?
> >
> > I hope that makes sense!
> >
> > Morgs
> >
> >

Hi, can anyone help please? I'm not sure which function I should be using
even!

If I have a list of people, address columns, postcode and a date in one
sheet so how can i return all the people (and all of their address and
postcode too) who are coming on a certain date to a different spreadsheet
(not using autofilter). There could be 10's or 100's that will match the
date criteria and I want all of them, not just one?

I hope that makes sense!

Morgs

Would like to create/print vocabulary flash cards. Have the word print on the
front and the definition on the back. Nothing fancy.

Later...THANKS!

how can i get todays date to auto load onto a page excel ?

Hi guys!

aim looking a simple formula to calculate the points and divisions of student score in excel.
first change numbers into letter
A starts from 100-81
B starts from 80-61
C starts from 60-41
D starts from 40-21
E starts from 20-0
after changing into A,B,c.... then you have to calculate the points for all nine subjects. here then
A have 1 point
B have 2 points
C have 3 points
D have 4 points
F have 5 points
divisions
I is between 7-17 points
II is between 18-21 points
III is between 22-25 points
IV is between 26-32 points
zero is between 33-35 points
for example
Anna have got Civics A, Chemistry C, Biology C, English B, Basic Maths C, History B, Geography C, Physics D and Kiswahili B then she have got Points 16 and Divisions I because you have to count only 7 subjects that she did best and also if she have got F in Mathematics and Civics and she obtained division I or II, she/he must be penalized to division three (III). for instance she obtained division I Points 15 then she must have III points 15.
looking forward to get the solution remember to select only seven subject that s/he has performed best

Hello

Does any one know how to add a word or number at the front and end of the column
example

BAM-022311 BAM-022411 BAM-050200P2 TO add WEBOE in the front

WEBOEBAM-022311 WEBOEBAM-022411 WEBOEBAM-050200P2 WEBOEBAM-051900P2

My next one I need help in is place a a number at the end but have it go up each row

example

WEB00000
WEB00000
WEB00000

TO
WEB000001
WEB000002
WEB000003
WEB000004

and so on.

Column1
0021D8B9B5FE
0021D8B9B494
001FCAE8A6B1
0021D8B9B6BF
001FCAE88DEE
0021D8B9AD96
001FCAE8A9C8
0021D8B9B5F7
0021D8B9B90E
0021D8B9B758

I want to sort on the last digit on each value:

for example:
0021D8B9B5FE
If last digit start with 1,3,5,7,9,a,c,e (consider this odd numbers)
if last digit start with 2,4,6,8,0, b,d (sondifer this even)

So how can I sort each raw based on the last character being odd or
even in excel.

=thanks in advance

how can i select all the cells with same color on a sheet if there are
multipale colors by vba code

We have a column labeled "Comments." Each cell contains a large amount of
text. The complete text shows up in the formula bar. How do I print out the
total contents of a single cell? I have turned on the Wrap button and done
the Format - Row - Autofit command.

how can i print non-adjacent ranges on one page?

We have a column labeled "Comments." Each cell contains a large amount of
text. The complete text shows up in the formula bar. How do I print out the
total contents of a single cell? I have turned on the Wrap button and done
the Format - Row - Autofit command.

How can I print my excel worksheet showing formulas in the cells?

Hello. First I would let thank anyone in advance for taking the time to
assist me. My question should be easy to answer. I have setup some drop
down lists in one of my worksheets. The button with the arrow that opens the
list hides itself after I click on another cell. How can I print the list
view so I can reference the list for other worksheets?