New answers tagged

0

Bearing in mind the previous advice that white font may be visible on PDF printing, I use the following technique: Use a cell outside the print area with a "1" or "0" entry. I then refer to this field in the conditional formatting of all cells required not to print. If A1=0 then set format to white font. If A1=1 then set format to black or any colour ...


0

The easiest way is to enable typeover when you press the insert key and turn on underline. Whatever you type will be underlined and the lines won't move as you type.


0

Are you seeing the exactly same below shown screen when the options are grayed out? To make these options enable, click anywhere in the message body part. See the screenshot. If still you're not able to use format in the message then other method may be helpful for your concern. According to that while replying or forwarding any messages Outlook ...


1

I don't know of a way to sort based on surname, but I can help you format your data in such a way to obtain sorting by last name:- Assuming your column has two words separated by a space, insert a column next to (to the right of) your current name column. (If you have more than two, say n space-separated words, insert n-1 columns) Select the column with ...


0

Create your conditional format rule. Open the Conditional Formatting Rules Manager Show formatting rules for: This Worksheet Click on the line for the rule to select it. Enter =$B$1:$B$999 (or the end of your data or even =$B:$B) in the Applies To box. Click OK. This will apply the rule you entered to the column B.


0

Create a range of cells you want to clean up, then try something like this. if instr(rng,".??") > 0 then rng.NumberFormat = "#,##0.00:-#,##0.00" If you want to provide a little better information about your data structure, my answer would be more specific to your problem.


0

%% Start by creating a Word Document Word_COM = actxserver('Word.Application'); set(Word_COM,'visible',1); RAM_Report = invoke(Word_COM.documents,'add'); invoke(RAM_Report.paragraphs,'add'); ReportDoc = Word_COM.Selection; %% ReprtDoc Created ReportDoc.Paragraphs.Alignment = 1; MyTextWithLineFeed = sprintf('%s\n','Hello World')...



Top 50 recent answers are included