Thanks to antville.org
Comments in Word

Word supports comments feature just like excel does.
To add a comment select a word and then use the keyboard shortcut Ctrl + Alt + M Or click on "New Comment" option on Reviewing toolbar.

To delete the comment right click on it and choose "Delete Comment" or choose "Delete all comments" option on Reviewing Toolbar.

... Link (0 comments) ... Comment


How many days til Christmas?

I was asked this today by my kids so in order to give an exact answer I write this equation.
=DATE(2005,12,25)-TODAY()

... Link (0 comments) ... Comment


Outlook tip

Outlook provides some visual clues about dates. For example, any date that is bolded includes one or more scheduled items. One way to view multiple days, is to left click and drag your mouse over continuous days on the calendar such as Monday through Friday. However, sometimes you need to compare days that aren't sequential. In that case, after you click the first date, pressing the "Ctrl" key, click any additional dates, to view different dates in different columns.

... Link (0 comments) ... Comment


Backing Up Excel

The customized changes made to menus and toolbars are saved in a file with the extension .xlb.
In Excel 97 and Excel 2000, the file name is the user's name followed by .xlb.
In Excel 2002 and Excel 2003, the file name is Excel.xlb.
To backup the file:
1. Search for a file with the extension .xlb.
2. Copy the file and store it in a safe place.

... Link (0 comments) ... Comment


Limiting scroll area in Excel

To set the Scroll Area range, click the Properties icon from the Control Toolbox toolbar. In the Scroll Area text box, type the scroll area range.
(To cancel the Scroll Area restricted range, clear the Scroll Area text box.)
Note: You cannot add two Scroll Areas to the Scroll Area text box.

... Link (0 comments) ... Comment


Count Characters in a Excel Cell

To count the total characters (including spaces) in cell A1:
=len(A1)
To count the total characters (not including spaces) in cell A1:
=LEN(SUBSTITUTE(A1," ",""))
To count the total specific characters in Cell A1, for instance the number of times the letter "d" appears in cell A1:
=LEN(A1)-LEN(SUBSTITUTE(A1,"d",""))

... Link (0 comments) ... Comment


Line Breaks in Formulas

If you want to put an address in cell on multiple lines, you can use CHAR(10) (10 being the ASCII code for a line feed).
=c3 & CHAR(10) & C4 & CHAR(10) &C5
If you get a bunch of squares and your text is all on one line, go to Format > Cells > Alignment and check the Wrap Text box.
To create a line feed while typing (i.e., not in a formula), Alt+Enter does the same thing.

... Link (0 comments) ... Comment


Text To Date Conversion

This is a procedure that I often use to convert dates originating from mainframe downloads into an Excel readable format. The dates come across in the following eight character format -> “20040101” - (Jan. 1, 2004).

Sub StringToDate()
Dim d As Range
Dim r As Range
On Error Resume Next
For Each d In Range("A1:A10")
d.Value = Format(DateSerial(Mid(d, 1, 4), Mid(d, 5, 2), Mid(d, 7, 2)), "yyyy/mm/dd")
Next
End Sub

The macro would need to be modified using the Mid worksheet function to allow for differing string lengths.

... Link (0 comments) ... Comment


Date Formats in Headers / Footers

When Excel adds a date to a header or footer, the default appears in the “MM/DD/YY” format. You can change this formatting via the following example:

Sub Change_Format()
ActiveSheet.PageSetup.CenterHeader = Format(Now, "MMM DD, YYYY")
End Sub

... Link (0 comments) ... Comment


Simple Worksheet Auditing

These simple VBA routines will quickly highlight cells with formulas, constants, text, or errors. They're great for auditing worksheets.
Sub MapFormulas()
Cells.SpecialCells(xlFormulas).Interior.ColorIndex = 6
End Sub

Sub MapConstants()
Cells.SpecialCells(xlConstants, xlNumbers).Interior.ColorIndex = 6
End Sub

Sub MapText()
Cells.SpecialCells(xlConstants, xlTextValues).Interior.ColorIndex = 6
End Sub

Sub MapErrors()
Cells.SpecialCells(xlFormulas, xlErrors).Interior.ColorIndex = 6
End Sub

... Link (0 comments) ... Comment


Online for 8160 days
Last modified: 10/13/24, 10:18 AM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
December 2024
SunMonTueWedThuFriSat
1234567
891011121314
15161718192021
22232425262728
293031
October
Recent updates
Extract words Extract all incorrect
words in first.txt file and all correct ones in second.txt...
by shantanuo (10/13/24, 10:18 AM)
Remove hyperlink in LO writer
1) Select "Internet Link" from Character styles. 2) Right click...
by shantanuo (10/9/24, 8:09 AM)
Templates in LO writer 1)
File > Templates > Save as Template 2) Give it...
by shantanuo (10/9/24, 8:07 AM)
discretize continuous features You can
"discretize" or "bin" continuous features into categorical features. from sklearn.preprocessing...
by shantanuo (4/24/24, 9:33 AM)
User Defined Property You
can create User Defined Property in libreoffice writer. File – Properties...
by shantanuo (1/9/23, 8:52 AM)
Arranging Chapters in the Navigator
To use a custom paragraph style for a heading, choose...
by shantanuo (1/4/23, 8:26 AM)
Use focus mode using Android
phones Settings > Digital Wellbeing and parental controls. Tap your...
by shantanuo (1/1/23, 3:59 AM)
Embed Fonts in document If
you use a font that the recipient is unlike to...
by shantanuo (12/18/22, 10:07 AM)
Using Navigator in Writer To
open the Navigator, select View > Navigator, or press the...
by shantanuo (12/18/22, 10:06 AM)
More about hyphenation The settings
for Tools > Options > Language Settings > Writing Aids...
by shantanuo (12/18/22, 10:04 AM)
link or unlink template If
you are using Libre office then template changer extension is...
by shantanuo (12/16/22, 5:27 AM)
Finding Styles you can select
Edit > Find and Replace > Other Options > Paragraph...
by shantanuo (12/14/22, 7:17 AM)
regex in clac In LibreOffice
Calc, you can use function REGEX for e.g. Begins with...
by shantanuo (12/14/22, 4:40 AM)
Libre Calc tips Turn Off
Grid Lines If you want to turn off grid lines...
by shantanuo (12/13/22, 8:14 AM)
More about Styles You can
goto View - Styles and change "All Styles" to "Applied...
by shantanuo (12/13/22, 7:49 AM)
Page Break Before Every Chapter
If your chapter titles are using the "Heading 2" Style:...
by shantanuo (12/13/22, 6:36 AM)
View and print in different
color Displaying Color in LO but Printing as White Page...
by shantanuo (12/13/22, 6:26 AM)
Change Normal Template in Libreoffice
Writer 1) Open a new file and set your font;...
by shantanuo (12/12/22, 8:45 AM)
Short english words in Devanagari
The list of short english words written in Devanagari. #...
by shantanuo (10/5/22, 9:05 AM)
Card issuing banks CITI
Standard Chartered HSBC American Express HDFC ICICI AXIS INDUS IND Kotak...
by shantanuo (7/16/22, 4:46 AM)
Activate IAM Access To activate
the Activate IAM Access setting, you must log in to...
by shantanuo (7/12/22, 5:52 AM)
use cheat instead of man
wget https://github.com/cheat/cheat/releases/download/4.2.3/cheat-linux-arm64.gz gunzip cheat-linux-arm64.gz chmod 770 cheat-linux-arm64 ./cheat-linux-arm64 mv cheat-linux-arm64...
by shantanuo (7/4/22, 8:53 AM)
python module itertools list of
useful methods of itertools module. permutations combinations combinations_with_replacement zip_longest count...
by shantanuo (9/8/21, 7:50 AM)
wikipedia tools 1) Collection of
useful utilities https://wikipediatools.appspot.com/ 2) all history of a user https://xtools.wmflabs.org/ec/mr.wikisource.org/Shantanuo...
by shantanuo (8/20/21, 6:36 AM)
Duration/Term of Copyright In the
case of original literary, dramatic, musical and artistic works, the...
by shantanuo (8/20/21, 6:26 AM)

RSS feed

Made with Antville
Helma Object Publisher