Know Your PC's IP

You may need to know the IP number of your PC at any time for any purposes. You can get it easily by searching in Google.com

1. Go to http://google.com
2. Search "see my ip"
3. Get your result.

Microsoft Excel Un-Answered Searches: Regular Update

We keep searching some MS Excel matters and often end up with solution like Macro, VBA or "No Solution". Yes, here are some points I am still stuck on any one of stated option. I haven't given up, just keep searching and keep updating the below list. You can contribute with solution here in comment part.

Looking For	Status	More to Add
Shortcut for changing cell background color. I already know, "F4" for format copy and "Alt, H, H" way. But What is required is, use the same selected color in same file in repeated way.	Looking for Solution
In Pivot table while you select column (in Pivot Environment) and drop to "Value" area, sometimes it shows as "Count". Is there any way to change the type of value calculation all at once? Like Sum, Count, Percentage for more than items together once; or a change in setting is also fine	Looking for Solution
Unhide multiple sheets all at once.	Looking for Solution

Try to contribute... and let the thirst for building efficiency continues.

Microsoft Excel Shortcuts: Regular Update

Excel shortcuts are amazing. We love to learn and keep learning. But the fact we don't like is, we forget is even faster just for lack of practicing. What if, we maintain a table of MS Excel shortcut and keep updating it, and look back while we need a particular one to revisit! Well, here I share mine.

Area	Action	Description	Keys
Anything	Redo	Redo	CTRL + Y
Cell	Hide	Hide one more digit of the number after decimal	Alt, H, 9
Cell	Move	One Row Up	SHIFT + Enter
Cell	Select	Select Cells: Select all Adjacent cells	CTRL + SHIFT + End
Cell	Show	Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.	CTRL + SHIFT + 1
Cell	Show	Show one more digit of the number after decimal	Alt, H, 0
Column	Hide/Unhide	Hide/Unhide Column	CTRL + 0 / CTRL + SHIFT + 0
Column	Select	Select Whole Column	CTRL + Space
Dialogue Box	Show	Appear Move or Copy Sheet Window	Alt, E, M
Dialogue Box	Show	Displays the Save As dialog box.	F12
File	Move	Switches to the next workbook window when more than one workbook window is open.	CTRL + TAB or CTRL + F6
Filter	Add	Add/Remove filter	CTRL + SHIFT + L
Format	Repeat	Repeats the last command or action, if possible.	F4
Formula	Add	Set Anchor ($) within a Formula. Use while your cursor in a cell in formula	F4
Formula	Show	% Shows	CRTL + SHIFT + 5
Formula	Show	Display Formulas	CTRL + `
Formula	Sum	Sum All together	Alt + "=" (Equal)
Menu Bar	Hide/Unhide	Displays or hides the Ribbon, a component of the Microsoft Office Fluent user interface.	CTRL + F1
Mouse Action	Show	Shows Right Click options, if you don't have mouse	SHIFT + F10
Pivot	Select	Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, it selects the entire PivotTable report.	CTRL + SHIFT + 8
Row	Select	Select Whole Row	SHIFT + Space
Row	Hide/Unhide	Hide/Unhide Row	CTRL + 9 / CTRL + SHIFT + 9
Row/Column	Add	Add Row/Column (After selecting row/column)	CTRL + "+" (Plus)
Row/Column	Freeze	Freeze Rows and Column	Alt, W, F, F
Table	Border	Table All Borders to Selected Cells	Alt, H, B, A
Work Sheet	Add	Add New Sheet	SHIFT + F11
Work Sheet	Delete	Deletes active Sheet	Alt, E, L
Work Sheet	Hide	Hides Active/Selected Sheets	Alt, O, H, H
Work Sheet	Rename	Rename Active Sheet	Alt, O, H, R
Work Sheet	Select	Selects the current and next sheet in a workbook.	CTRL + SHIFT + PAGE UP/DOWN
Work Sheet	Show	Show Hide/Unhide Sheet box	Alt, O, H, U
Zoom View	Show	Appear Sheet Zoom View Dialogue Box	Alt, V, Z

And I'll keep updating it while need to.

'Uncodist' Uncoded

I'm one of the few lucky individuals who touched the keyboard in early 90's, enjoyed full flavor of texty MS-DOS and Word Perfect 5.1, instead of friendly MS-Office. But I'm not that much lucky to owe one (computer) at that time. It was 2001, if I'm not wrong.

After some couple of months, I discovered website as a powerful media, which is cheap from cost perspective. That time I didn't have any training, or any formal education; and it's true till today. But what happened? Being a student of business studies how I came to learn web making? The answer lies in some dedicated writers in the web world, they are commonly known as 'Tech Bloggers'. I appreciate those great works of spreading knowledge which support great innovations. Since I have learned from those webs, I'm greatly thankful to them and their works.

Now, despite of having so many great contributor, why an illiterate like me start talking on this topic, where he's still a Zero! Well, here is it. For my website, while I look for required codes and information, many a times, I found some write-ups are not friendly enough. Roughly it can be better told, they are lack of image, easy language and weak demonstration. Some of them just have the headline and lots of texts but not required information.

And all these, make me to start writing for IT. This site will be mainly a "How-to" page majorly covering IT and related issues. It may light on other different relevant issues. Language may be both, Bangla and English; but it doesn't mean a translation. Let's see how far it can go.

Keep connected.

Uncodist - an initiative of SHAON84, can be reached by: uncodist.shaon84.com

Uncodist Test Blog

'Uncodist' from SHAON84, will be 'uncoded' on 13 December 2012. Keep in touch till the coded site gets decoded. - SHAON84 (www.shaon84.com).