what is the function and name is of the symbol in each table cell.
Under Paragraph I clicked the Show/Hide Symbol icon so I can now see a
symbol at the end of each text within a table cell.
I wondered what that is so I tried to use Help to find out.
I did find help that mapped a word (like paragraph) into a symbol.
But I can't find anywhere where if I know the symbol it will tell me the
Can you tell me how to find such info?
Or maybe you can tell me what the function and name is of the symbol in each
I'm sorry, I meant to sent this to the Word group.
Of course, I wouldn't mind getting the info...Copying data from one chart to another
I have many graphs - all plotting on similar scales but using different
data. Is there any way I can simply copy one set of data from one graph
and paste it into another graph so that I can avoind going through all
the hassle plotting each curve again? I want to have graphs showing
different combinations of the same data and have hundreds of curves to
plot so this could be a huge timesaver...
Alan_Partridge's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29295
V...need custom cut and paste functions
I once wrote here about a problem I had cutting and pasting where columns
would turn to "REF!" after a cut and paste. I would work around it by
copying, pasting and then manually deleting instead. I thought turning
everything in the sheet to absolute references would solve the problem but
it didn't so now I am thinking of a different solution.
Could someone tell me what I need to do to write my own cut and paste
functions which would basically copy the selection and then on a paste it
would paste and then delete the original selection from where it was copied
from...Moving from Home & Student to Full version of Office
Operating System: Mac OS X 10.5 (Leopard)
I need Exchange support and therefore I am planning to buy the Full version of MS Office 2008 for Mac. I already purchased and installed (and have been using) MS Office 2008 Home & Student edition.
My questions are:
1. Should I uninstall the Home & Student edition before installing the Full version? (I assume so).
2. How do I make sure that the data I have already created in Office 2008 Home & Student edition will be available to me after installing the Full version? In particular, how do I make sure that ...copy-paste from excel to powerpoint
When I copy a number of cells from Excel to powerpoint, I can't get rid of
the grid lines. There are no borders. When I'm in Excel, I see the faint
grid lines as you normally would. Unfortunately, these lines also display in
powerpoint. How do I stop that behaviour.
Thanks so much for any help.
Select all the cells you are copying. Then:
Format > Cells... > Patterns Then select white color ( bottom right)
When the backgound color is set the gridlines vanish unless borders are
> Off...Excel 2003 Copy/Paste filtered column
I have a filtered column on my spreadsheet. I have copied the column,
changed the figures and then tried to paste it back on to the filtered
column. It is not copying over the original filtered column but rather over
cells that have been filtered out. The worksheet/cells are not protected.
What could the problem be?
That's the way pasting works. It'll hit the visible and hidden cells.
> I have a filtered column on my spreadsheet. I have copied the column,
> changed the figures and then tried to paste it back on to the filter...Function doesn't run
In my spreadsheet, I have the following function
=VLookup(K16, zips, 2)
However, instead of returning a result, the function remains in the
cell. How do I fix this problem?
Format the cell as General and re-enter the formula (F2, ENTER)
Microsoft MVP - Excel
"Justin" <email@example.com> wrote in message news:firstname.lastname@example.org...
| In my spreadsheet, I have the following function
| =VLookup(K16, zips, 2)
| However, instead of returning a result, the function remains in the
| cell. How do I fix th...Copy Matrix Items
I am afraid I know the answer to this already but here goes-
I have a prospective shoe store customer who receives as many as 500 pairs
of shoes in a lot. Most of the time 50% or more of these shoes have not
been stocked before and they don't know what the shoes will be until they
get the lot. Because of the nature of shoes they need the ability to
quickly enter in the assorted sizes and colors in a run of Men's, Women's,
Children's etc. While the New Item Wizard for a Matrix Item works well the
customer would like to not have to enter in the size runs each time since
they a...How to copy aQuery to a new Table?
I have a database in a Table, a report based on that same Table and a Query
based on that Report.
After two months or so I like, after some new data input, to save the Table
into a new Object Table. What is the best way for the Report and Query to
follow the new Table whitout recreating the original Report & Query?
Thankyou for your comments. I use MS Office Access 2007.
>>I have a database in a Table, a report based on that same Table and a Query
based on that Report.
Your phrasing is wrong when it comes to the elements of an Access database.
A dat...Adding a button with a function on protected sheets.
How do i add a button to 'reset/clear' the data on a worksheet that is
protected and uses VLookup data (from another worksheet).
Everyday this table will have data chosen from combo boxes or manually
entered in allowable editable fields and at the end of the day after the
files is saved, I need to clear that data for use on the next day.
How is this Reset button applied with allowable edit ranges, VLookup data
and a protected worksheet?
There's several ways to do this.
1. Instead of straight vlookups, use
=IF(ISBLANK(VLOOKUP(....)),"",VLOOKUP(....)) wher...Today Function
how is this function called in the code?
I want to use in in an update query that is coded to a button.
I hope I'm understanding what your asking for but I think this is what you
are looking for:
>how is this function called in the code?
>I want to use in in an update query that is coded to a button.
Message posted via AccessMonster.com
Well I think it is either
not sure which and not sure how to use it in the code.
I ...Copy/paste range of rows between 2 dates...
Hi! I have a sheet called data which act as a database. The column A has
the dates. In order to create customized chart in a userform, for
different range of data(i.e from column D, G and M...), I'd like to
select a range of rows that are between 2 dates and create the charts
accordingly. Or copy to range to another sheet and then create the
charts. I am not so advanced in VBA and any help would be greatly
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
..."Can't copy the items. You don't have permission ..."
I use OL 2003, latest service pack,etc. My PST file is about 1.2 GB
and is Unicode-compatible.
Lately Outlook shuts down suddenly without warning, and I have left
checked the box to restart Outlook automatically. This is a big
annoyance. However, in the last 2-3 days, I'm seeing a new kind of
problem. I can't delete or move messages from mail folders.
I get the message that is in the subject line, and the balance of this
... to create an entry in this folder. Right-click the folder and then
click Properties to check your permissions for the folder. See the
folder o...how can I asign printscreen to a function key or key combination?
My key board has no printscreen key. What can I do?
That seems unlikely, but it is hardly a Word issue. The PrtScn button is
usually a dual function button somewhere on the top row of your keyboard. If
it is not then you need to ask the keyboard manufacturer.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< ...Volume License copy of Windows Server
Is there anyway anymore to get a full Volume License copy of Windows Server
(e.g., version 2008) which does NOT require Internet activation?
Start with Vista/Windows 2008, your options to activate are by Internet or
Phone. I believe the command that kicks it off is:
"Spin" <Spin@invalid.com> wrote in message
> Is there anyway anymore to get a full Volume License copy of Windows
> Server (e.g., version 2008) which does NOT require Internet activation?
...Users cannot login to OWA after Exchange 2K3 was moved into different OU
I created a new OU named member servers, and moved the
exchange 2k3 server into it. After I moved it, only the
administrator was able to login to OWA successfully. No
users could login to OWA. I created a test account with a
mailbox, and was able to login to OWA with the newly
created test account. I then moved the exchange 2k3
server from the member servers OU into the computers OU,
and the newly created account was unable to login to OWA.
Any help with this would be appreciated.
...Copy of all in/out mail in another mailbox
My management in intrested to receive all the in/out mails
of all the mailnboxes in another mail box to check what
other emplyees are sending and receive.
Is it possible in MS Exchange 2000 or 2003, if yes how?
Yes, it's possible. See this:
For Exchange news, links and tips, check:
"Jaffar Ali Sayyed" <email@example.com> wrote in message
> My management in intrested to receive all the in/out mails
> o...Moving certain data to different sheet
I need to move data that meets a certain criteria, to another sheet within a
workbook. For instance, if a column of data is for a certain ZIP code area, I
need it to automatically copy to a sheet for that city. Say, 40202 would go
to the Louisville, KY sheet. Because Louisville has multiple ZIPs, I would
need only the data that begins with 402 to go to that sheet. Lexington KY's
data, which begins with ZIP code 405, would go to its own sheet. Macro?
This can definitely not be created with a formula. I suggest that you make
use of the macros.
Kris...Pie Chart Plot Area Moves
After printing a pie chart, the plot area relocates itself. I wrote a
procedure to bring it back to the designated "top" and "left" coordinates
the next time the sheet is activated, but the plot area doesn't relocate
until the sheet is activated a SECOND time. Does anyone know how to fix?
...Show picture outline only when moving in PowerPoint
It's probably simple when you know it, but I'm sure there's a setting that I
can toggle, so when I move a large picture in PowerPoint, only the outline
shows, not the whole picture. This is because the pictures I'm inserting need
to be of good quality, and my laptop struggles with them when I move them.
...You cannot copy or move messages to public folders
I have a few users who get the following error when trying to move messages
from their inbox into a public folder -
"Can't move the items. You do not have sufficient permission to perform this
operation on this object. See the folder contact or your system
I have found the following on microsofts website and have made those changes
but it has not solved the issue http://support.microsoft.com/?kbid=330752
has anyone seen this before?
I have also downloaded outspy and run this on messages that have failed and
on messages that are ok. However im not really su...Move server between Admin Groups #2
We are going to be going through a reorganization soon and will need to move
some exchange servers from one admin group to another. I know there is not
a native way in Exchange 2003 to do this. Does anyone have ideas on how to
accomplish this besides a swing server to the new Admin Group?
Third party Software?
Our environment is 2003 Forest functional and domain level. Exchange 2003
On Tue, 3 Jan 2006 14:16:23 -0500, "Tim Kalligonis"
>We are going to be going through a reorganization soon and will need to move
>so...Prevent copy and paste in one column
I am having trouble trying to prevent copying and pasting in one specific
column. The code refers to the specific range, but yet it prevents copying
and pasting on the whole worksheet.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Columns("H:H")) Is Nothing Then
Application.CellDragAndDrop = False
Application.CutCopyMode = False
Application.CellDragAndDrop = True
Works for me in Excel 2003
Gord Dibben MS Excel MVP
On Fri, 30 Apr 2010 11:42:01...Copying of non-consecutive, columnar data into consecutive-columnar cells
I have data located at a1:a9, then a:10 is blank; then, I have 9 more
lines of data from a11:a19, and a20 is blank...
a1, a11, a21...are all the texts/numbers that I want printed on a
different page. But here's the catch: I'd like to print it at
locations a1, a2, a3...
Specifically, the data that I have appears like this on
THIS IS ON SHEET 1:
A1: prefix: Mr
A2: emailAddress: firstname.lastname@example.org
A3: firstName: John
A4: lastName: Smith
A5: company: ABC Company
A7: prefix: Mrs
A8: emailAddress: email@example.com
A9: firstName: Kim
A10: lastName: Davids
A11: company: X...copying column width in tables
I created a table in Publisher with 6 columns. I would columns #1, 2,
4 and 5 to have the same width and columns 3 and 6 to have a different
width. I'd like to set the width of column 1 and then paste that size
to the other four so they all have exactly the same width. Presently,
I am eyeballing it, but it takes too much time and is not exact. Any
ideas on how to do this?
The only way is to create guides. Arrange, ruler guides. You could try creating
a table in Word, copy/paste.
Mary Sauer MSFT MVP