Know Details About A Registered Web Domain Address

You can find yours or any specific domain's basic details like: Domain creation date, expiry date, last update date, owner's name, phone, E-mail address, mailing address, name servers etc. in one authentic source. Go https://who.is, type your desired full domain name in a box like below,

Screenshot: Who.is Domain Search Box

For the site like "google.com", you are to type "google.com" in the box, and hit enter. The return page will give you publicly available information about the domain. The return page address would look like: https://who.is/whois/google.com

Simplifying the Return Address

You can directly enter to required information page even by following below way (this is unofficial)

Return Address: https://who.is/whois/google.com

Simplification: <whois web address> / <whois> / <required website address>

There are many pages who shares similar information. But to me ,that seems most authentic.

Please share your feedback to below comment box, like the Facebook page and tweet (all given side panel).

Upload Web Site Files Via FTP Without Any Software

There are several free software available for uploading your website's files via FTP (File Transfer Protocol) facility. Your website hosting server must have this feature available to enjoy this. FTP allows you uploading multiple files all at once, and you don't need to update one file each, separately.

Apart from using any software you can upload files in your website without any software; directly upload files to your website from your windows explorer just like copying files in your PC's folder.

Follow below steps.

Step 1: Go My Computer

Go to My Computer. Type: "ftp://<Your Full web Site Address>" in address bar. For example: ftp://google.com

Step 1: Go to My Computer

Step 2: Login

A below box will appear. Type your FTP Server Username and Password; then hit enter. Contact to the company from where you have bought the domain-hosting for FTP Login Name and Password, if you don't know.

Step 2: Login Window

Step 3: Upload Files

Once logged on, a familiar Windows Explorer like window will appear. Hope the next you can manage by yourself. Usually your web files are available to the folder named: "public_html". For uploading any file, just copy your files, and paste to desired folder/location. You can easily create folder within the area, by right clicking of the mouse. Close the explorer once you are done.

Step 3: Get to Within Your Web Files' Area

Please share your feedback to below comment box, like the Facebook page and tweet (all given side panel).

Simple Border Around A Picture in Photoshop using Stroke Option

In many ways you can draw border around a picture in Photoshop. Below screenshots are of Photoshop CS4.

Open the file in Photoshop which you want to border.
Select All by pressing "Ctrl + A"
Press Right Button putting mouse on the picture. Select "Stroke..."
Now change border size (Width), Color (Color) by changing option. In Location select "Inside".

Screenshot: Picture Border via Stroke in Photoshop

Now save and exit.

Please share your feedback to below comment box, like the Facebook page and tweet (all given side panel).

Adding Facebook Page Badge in Blogger Sidepane

You can add Facebook Page badge in Blogger via Facebook iFrame code if you don't get favorable gadget to add.

In Facebook Side

1. Go > https://developers.facebook.com/docs/plugins/page-plugin. (You can also can reach the same location visiting number of pages. Go https://www.facebook.com/badges, click "Get Social Plugins", click "Page Plugin".)
2. Provide Page address, expected width (I have provided 250), height, check/uncheck required option as per requirement.
3. Click "Get Code". Select "IFrame", and copy the code.

Picture: Facebook Page Plugin Area in Facebook

Picture: Java/HTML Code Box in Blogger

In Blogger Side

1. Login to your blogger account, click "Layout".
2. Click "+ Add a Gadget"
3. Find and click "HTML/JavaScript".
4. A new window will appear. provide a heading, example: "ABCD Facebook Page".
5. Now, paste the IFrame code which has been copied from Facebook.
6. Click Save, and see preview.

Picture: Sample outcome in right pane of your blogger page

Please share your feedback to below comment box, like the Facebook page and tweet (all given side panel).

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.