вівторок, 23 червня 2020 р.

Delete infinite rows and columns in MS Excel / Google Sheets

Excel is a pretty powerful tool, but in order to get the most of it, you need to customize your sheets.
By default it might have so many rows and columns that you might want to get rid of.
This is how to do it

  •  Ctrl+Shift+Right arrow to select all columns on the right from the current one
  •  Ctrl+Shift+Down arrow to select all rows below the current one
Then just simply chose "Delete columns"or "Delete Rows".
That's it!

References:

четвер, 4 червня 2020 р.

AWS: Get AWS AccountID from CLI

Here's the way to quickly find your AWS details, including account ID, from CLI
aws sts get-caller-identity
To get AccountID only, use queries and customize output text
aws sts get-caller-identity --output text --query 'Account'

That's it!

References: