What must I do to get gridlines printed for both filled and empty cells?
What must I do to get gridlines printed for both filled and empty cells?
I'm a teacher, and I'm trying to replicate and print, in Excel, an
attendance book format, with a series of tiny squares next to each student's
name. The printed form of this would allow me to register if a student were
present or absent on a particular day.
Hubert Earl, vendor of fine Jamaican art, coffee, etc. on eBay:
Fine Jablum Blue Mountain Coffee sales page:
http://stores.ebay.com/Jamaican-Coffee-Art-and-More-Store_Jab...Sort Descending with IF and empty cells
I am trying to sort a column descending. The cells functions are
=IF(J38=0,"",I38/J38). I want nothing to appear in the cell if
the result is true, but this poses a problem when I run my macro for sorting
descending. It puts my blank cells at the top. Is there a way to sort
descending but have my blank cells all at the bottom? Any assistance would
Instead of returning "", you could return a large negative value, like
-9999. You can apply conditional formatting such that if the cell
contains -9999 the foreground co...Pivot Tables + Color + Dynamic Content generation and display #2
I have a dynamically generated pivot table (generated from actions in
another spreadsheet - number of rows and location keeps changing -
cant use conditional formatting).
The data I currently have displayed on the pivot table is:
Resource Project Allocation Jan Allocation Feb
-------- ------- -------------- --------------
Resource1 Project1 0.5 0.5
Resource1 Project1 0.25 0.5
Resource1 Total 0.75 1.0
I need to
(1) Highlight, in red, items where Resource totals are less than 1.00.
e.g. Resource 1 Total. Just...Outlook 03 can't resolve name on Exchange Server 4.0
When I try to connect the Outlook 03 client to the Exchange Server 4.0 I get
an Microsoft Office Outlook message box that says "The action could not be
completed. The selection specification is too complex. Use fewer or less
complex restrictions." This is a small business that only uses the Exchange
Server 4.0 for internal e-mail for six clients and they don't want to spend
anymore money to upgrade the Exchange Server which works fine on all the
other client computers. Thanks for your help!
On Wed, 17 May 2006 07:04:01 -0700, JamieP
<JamieP@discussions.microsoft.com>...Macro to Protect cells
Total Excel virgin here (and proud of it - LOL).
I'm putting together a sheet that will have a lot of cells that a
client will enter the values in, and then send to HIS client to fill
in the rest.
What I need to do, is pull up this sheet, allow my client to fill in
the fields he needs to, then run a macro to protect (password or
another variant) those cells.
As I will know each and every time which cells need to be protected,
what would the process be to create this?
If someone would at least point me in the right direction, I'd greatly
Cells are protected w...auto copy cell format
I have a complex spreadsheet in which I use cell formatting (shading) to
illustrate where one cell value is being copied elsewhere in the same sheet.
So for example I have a value 2.34 in cell C3 which is shaded pink, and
another cell G24 also 2.34 also shaded pink. It is helpful for display
I can set G24 to 2.34 just by setting the cell '=C3'. But can I set it to
pink in a similar way?
I have Excell 2007.
I know how to copy a cell format using the format painter, no problem. But I
have several cell connections of this sort and an automated way of doing it
w...CRM 3.0 Improvement Suggestion
Just trying to find Product Id's using Advanced Find at it is VERY time
consuming. One improvement that would immediately help is after you select
the field. E.g. ID, then a criteria e.g. Contains, then type in the ID you
CANNOT press Enter to start the search. You have to actually click Find,
which slows this process down. Any improvement on changing products by
searching for ID's or even allowing in the main table view to search by
Product ID would be a VAST improvement.
Thanks for your consideration.
Also after it has found the item(s) you were looking for and dis...New line in a cell
During writing text in a cell, I would like to make new line instead of
continuing writing. For example, a new paragraph.
Can anyone help?
You may have to drag the column wider
to get the proper length of the line.
Followup to newsgroup only please.
"Abe" <Abe@discussions.microsoft.com> skrev i en meddelelse
> During writing text in a cell, I would like to make new line instead of
> continuing writing. For example, a new paragraph.
> Can ...Filling a cell from a Macro
I want to put a IF formula from a Macro. IE. cell= "=IF(a=b,"yes","no")"
However this give an error on the " sign. How to proceed?
You need to double up on the " marks around the strings yes and no
Range("C1").Formula = "=IF(A1=B1,""yes"",""no"")"
Gord Dibben MS Excel MVP
On Thu, 13 Sep 2007 20:14:59 +0200, "Just Merks" <email@example.com> wrote:
>I want to put a IF formula from a Macro. IE. cell= "=IF(a=b,"yes&qu...Is there an easy way to swap the contents of two cells in Excel?
I think the subject says it all...
=?Utf-8?B?Ti5CLiBZb25k?= <N.B. Yond@discussions.microsoft.com> wrote in
> I think the subject says it all...
You could add a button to the sheet with following code behind it:
Private Sub CommandButton1_Click()
cel1 = InputBox("First cell?")
cel2 = InputBox("Second cell?")
c1 = Range(cel1).Value
c2 = Range(cel2).Value
Range(cel1).Value = c2
Range(cel2).Value = c1
You will be asked for the 2 cell addresses and the contents will be
...How can I format a cell so date field only displays the Month?
I'd like to have cells with date fields only display the Month. Instead of
MM-YY or MM-DD-YY...I'm looking for just MMMM.
On Fri, 3 Dec 2004 16:35:01 -0800, "tk_2u" <firstname.lastname@example.org>
>I'd like to have cells with date fields only display the Month. Instead of
>MM-YY or MM-DD-YY...I'm looking for just MMMM.
Format/Cells/Number Custom: mmmm
Right-click on the cell with the date in it > FormatCells > NumberTab >
Custom > ..type MMMM in the window
Vaya con Dios,
"t...CRM 3.0 over SSL
I am trying to change a CRM deployment so that it now is accessible
I have added the certificate to the CRM website with the name
crm.companyname.com and set the SSL port to 442.
Before changing the registry settings e.g. ServerURl I can access the
CRm website using:
but not using https://crm.companyname.com - I get you are not
authorized to view this page.
When I change the registry settings to https://servername:442/MSCRMServices
or https://crm.comapnyname.com:442/MSCRMServices and I use http://localhost:5555
https://servername:442...grouping cells #2
Is there a way to group cells together? I am sorting data on one sheet and
this changes 1 column in another sheet. I need to have all data in a row
where the 1st column sorted to move with the value from the 1st column. If I
could group them together or somehow link the whole row then if the 1st
column changes the rest of the info in that row would go as well.
In your rows, you need to have formulas (typically, VLOOKUP formulas) that extract the data based on
the value of the first column (if it is unique)....
MS Excel MVP
"johnrb78...whole rows, not cells
I want to protect a particular sheet so that the user can only select copy
and paste whole rows, not individual cells. Is this possible?
Maybe you could give the user a macro that would get the range to be copied,
extend it to the whole row, get the row to paste, unprotect the worksheet, do
the copy|Paste and then reprotect the worksheet.
Dim RngToCopy As Range
Dim CellToPaste As Range
Dim myPWD As String
myPWD = "hi"
Set RngToCopy = Nothing
On Error Resume Next
Set RngToCopy = Application.InputBo...Formatting text within a cell
I'm pretty new to Excel ... I want to emulate my formatting in Word of a
title with several bulleted subpoints indented and under it. Every time I hit
"Enter" for a new line, I get skipped to a new cell. Any help will be
When editing a cell, if you hold down the [Alt] key when you press [Enter],
that will put the subsequent text on a new line in the same cell.
Does that help?
"AV Guy" wrote:
> I'm pretty new to Excel ... I want to emulate my formatting in Word of a
> title with several bullete...Installing CRM 3.0 on two servers
In every installation of CRM 3.0 in an environment with two servers
(one for CRM and one for SQL/Reporting services) I am running in
various security issues which either have to do with CRM or with
Reporting Services or a combination of the two.
What are your suggestions on the security credentials under which the
different services comprising the solution should run under ?
Reporting Services is also something which causes issues. Any
suggestions "from the field" on this matter ?
Also, what needs to be done when the AD is based on Windows 2003 as
compared to AD which i...FILTER inclucing merge cell
Hi, I have below data
A B C D E
Row 1 PLACE CODE STATE CODE STATE
Row 2 USA CLIENT CLIENT COMPANY COMPANY
Row 3 2-10 SA 20-3 PO
Row 4 RUSSIA CLIENT CLIENT COMPANY COMPANY
Row 5 201 SR 90-1 OP
Please note that I had merge Cell A2 with A3, A4 with A5.
I applied autofilter but when I filtered PLACE with criteria USA, it only
USA CLIENT CLIENT COMPANY COMPANY
Is there a way to show as below
USA CLIENT CLIENT CO...Trendline to ignore empty cells
I am working on an Excel spreadsheet that contains 5 sheets of graphs and 5
or 6 sheets of data. I am trying to not show the trendline when a cell is
empty. I have found a couple of threads about this but do not quite
understand them and would appreciate your help!
Most of them refer to the NA() function but I am not sure where to enter
that and have it reflect in my chart.
I have an average price sheet that contains my total sales for each week and
some of those cells are empty. What would I enter into those empty cells so
they will not show on the trendline in my chart?
Thanks ...Find & Replace Cell Colors
Operating System: Mac OS X 10.6 (Snow Leopard)
Is there any way to find and replace cell colors in Excel? I know you can do this in Excel for PCs but is it an option for Mac users?
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
On 1/28/10 2:34 PM, in article 59bb1c81.-1@webcrossing.JaKIaxP2ac0,
"email@example.com" <bbagby@of...pasting a block of text into one cell
I'm trying to paste a few passages from a book, surrounded by a trim()
command, into a single cell of a worksheet. Since this has multiple lines,
and tabs at the beginning of each line, the paste occurs in multiple rows and
the trim() command doesn't work. Does anyone know how to paste something like
this into one cell?
For clarity, the block is like this:
(with tabs before each line)
Is there any way to do this? Any help would be greatly appreciated.
Try the =CLEAN(A1) function.
Tha...How do I graph a cell vs one that it changes for a range of valu.
One cell changes another cell as determined by a formula not explicitly
contained in either cell.
I want to range a cell from 0.5-1 in small increments and line-plot it vs
How do I express a range of values and the steps of increments?
> One cell changes another cell as determined by a formula not explicitly
> contained in either cell.
> I want to range a cell from 0.5-1 in small increments and line-plot it vs
> the other.
> How do I express a range of values and the steps of increments?
It sounds like you want a Data Table. Look in Excel's Help ...EXCEL AND VB6.0
MY Application is a web application.Client from the user system can upload a
EXCEL file for processing at WEBSERVER.
The Requirement is when the processing of excel is going any bad records
according to busines rule if found need to be written into a new EXCEL file.
The VB componet used for it refer a EXCEL object but at server according to
client wouldnt be any "MS OFFICE" Installed thu my program to generate the
EXCEL obejct refernce is not working.
Is there any way by which without installing MS OFFICE at webserver i can
create a EXCEL file.
THis is urgent please...Setting the color of a cell from a cell
I have two worksheets with similar data. In fact they are almos
identical. I would like to use a third worksheet to show the cell
which are equal as yellow and those which are different as red.
I have made an attempt at writing it, and have searched the forums, bu
can't find anyone trying to do this.
Here the cell formula in 'sheet3'!A1(copied to the whole sheet):
Here is my code for setColor():
Function setColor(R As Range, C As Integer)
For Each X In R
X.Interior.Col...Finding cells with leading characters
My spreadsheet looks like this:
Using EDIT/FIND, when I enter '68' in the "Find What:" box, Excel
finds A2, A5, A7, A8, A11 and A14 because their values contain '68'.
What do I enter in the "Find What:" box to find the cells whose values
BEGIN with '68'? (In this example, ...Export cells and creat word document
What I need to do is take the contents of cells in two columns and export or
save them to automatically create a word document. The content of cell in
first column would become a Heading 2 in word document and content of cell
in second column would be normal text below the Heading 2. When the html tag
<br><br> is found this would become a new paragraph. This would continue
until all cells have been converted.
Page Title Page Text
1. Title 1 text This is text for content under title 1
2. Title 2 text This is text for content under title 2<br...