Thanks to
Recover a Deleted Word Document

In Word, go to Tools, then Options. Under the File Locations tab, double-click AutoRecover files and make a note of that path location. Click Cancel and Close. Open up that folder in My Computer or Windows Explorer and search for any .ASD files.

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

Saving Filtering Criteria

To save filtering criteria, use Custom Views:

Step 1: Add the Custom Views icon to the toolbar

1. Place the mouse over one of the toolbars, right click, and select Customize from the shortcut menu.
2. Select the Commands tab.
3. From Categories, select View and drag the Custom Views icon to the Menu bar.

Step 2: Save the filtering criteria

1. Select a cell from the column containing the criteria you want to Filter with.
2. Click the AutoFilter icon
3. Type any text criteria you want into the Custom Views box and click twice to save.
4. Repeat the previous step and save as many filtering criteria as needed from any sheet within the workbook.

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

Returning the Smallest Non-Zero Value

I don't remember if I have mentioned this before, but if you want to return the Smallest Non-Zero Value, use array.

(entered by pressing Ctrl+Shift+Enter)

You can make the formula even shorter by turning it around in this manner:

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

Another old Excel bug

I have noticed an odd thing when it comes to creating CSV files with Excel: the files are not always consistent in how they end each row in the output data. When I create a CSV file that has, perhaps, 70 field (columns) of data and then views the CSV file in a text editor, I noticed that the records all contain carriage returns, but in different places. How do I get the CSV files to contain a consistent number of output fields.

This is actually a problem that has been known to Microsoft for quite some time. The Microsoft Knowledge Base includes an article on this topic as early as Excel 97:

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

Disable Paste Options

Excel include a feature that really annoys some people: Paste Options. When you paste some tidbit of information in your worksheet, Excel displays a small, floating "button" right near the end of the pasted information. Follow these steps to turn it off:

1. Choose Options from the Tools menu. Excel displays the Options dialog box.
2. Make sure the Edit tab is displayed.
3. Clear the Show Paste Options Buttons check box.
4. Click on OK.

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

Finding a line break

how to search for a line break (Alt+Enter) in a cell?
Press Ctrl+F to display the Find tab of the Find and Replace dialog box. In the Find What box, hold down the Alt key as you type 0010 on the numeric keypad.

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

Printing a Multi-Line Footer

You can create a multi-line header or footer in Excel. The trick is to remember that you cannot press Enter while typing your footer. Instead, to start a new line you should hold down the Alt key as you type 0010 on the numeric keypad. This inserts a line-break character in the footer text. The total length of a header or footer cannot exceed 255 characters.

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

Picking Up in the Last Document Edited

you can jump to the last place that you edited in a document by pressing the Shift+F5 key. In other words, open the document, press the shortcut, and the insertion point jumps directly to the last edit point in the document.

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

Excel formula tip

While you enter a formula in a cell, press CTRL+SHIFT+A to see the arguments in a formula. If you type =RATE, and then press CTRL+SHIFT+A, you can see all the arguments for that function--for example, =RATE(nper,pmt,pv,fv,type,guess).

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

Excel Tips

Quickly Typing Dates into Cells

Typing a large amount of data into cells can be tiring, especially if it includes a series of dates. Type the day (serial number only) into cell A1 and add the following formula to insert the month and year into cell B1:


Type a full number in the cell and change it to a date by using the following formula:

=DATEVALUE(LEFT(A1,2)&"/"&MID(A1,3,2)&"/" &RIGHT(A1,2))

For example, type 122203, the result is 12/22/03.


Counting number of unique entries in a specified range

By using SUMPRODUCT along with COUNT to count only the number of unique entries in a specified range. The range can be all in one column or row, or may span multiple (adjoining) columns/rows.

The formula would be written as: =SUMPRODUCT((1/COUNTIF(A1:C5,A1:C5&""))) where A1:C5 is replaced with the range you want to apply the count to.


Retrieving an Item from a List that Meets Multiple Criteria

Range A2:C7 contains a list of items and their corresponding colors and prices. We want to find the name of the first Blue item that costs less than $200.

Use the INDEX and MATCH functions as shown in the following Array formula:
{=INDEX(A2:A7,MATCH(1,(B2:B7=D2)*(C2:C7 < D3)))}


Color numbers based on the value result in Microsoft Excel

There are two ways to color numbers according to criteria:

* Custom formatting for a number with criteria
* Conditional formatting

Using custom formats for numbers with criteria
Your options for coloring a number are not limited to displaying negative numbers red. You can color positive and/or negative numbers in any color you wish (do not get excited - the number of colors is limited to eight, and most are difficult to read). Do this by adding the name of the color to the number format in brackets.

Example: [BLUE] #,##0 ;[RED](#,##0)

A positive number is displayed in blue; a negative number is displayed in red; and 0 is displayed in blue (since there is no third section, 0 receives the format of the positive number by default).

Add a condition to the formatting, and have each section be displayed in a different color: [BLUE] [>5000]#,##0 ;[RED](#,##0); #,##0


Indicators for the maximal and minimal values
Creating a formula that will indicate the maximum and minimum values in List1 by returning ""Max Value"" or ""Min Value"" in the cell next to them.

Enter the following IF statement, using the MAX and MIN functions, in column B: =IF(A2=MAX($A$2:$A$8),""Max Value"",IF(A2=MIN($A$2:$A$8),""Min Value"",""""))

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

Online for 7856 days
Last modified: 1/9/23, 8:52 AM
Youre not logged in ... Login
... Home
... Tags

February 2024
Recent updates
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 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 2) all history of a user
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)
Preserve seeds 6 types of
seeds to be preserved for next season. 1) laal Mula...
by shantanuo (5/7/21, 5:46 AM)
Why do I care for
Linux? I don't care that much for other software. Linux...
by shantanuo (12/17/20, 9:27 AM)
important leafy vegetables 1. Amaranthus
caudatus: rajgira. 2. Amaranthus tricolor: Math.  (Chhoti Chulai- Hindi, Cheera-...
by shantanuo (4/12/20, 2:01 PM)
program creek program creek
seems to be a good site for handy references of python...
by shantanuo (4/11/20, 11:24 AM)

RSS feed

Made with Antville
Helma Object Publisher