Questions tagged [formatting]
Process of preparing a disk for storing data. Specifically, "high-level formatting" involves the creation of a new file system and/or a boot sector. For text formatting, use [text-formatting].
1,274
questions
0
votes
0
answers
27
views
How to remove values in conditional formatting
I have conditional formatting rules applied to a workbook. When a user selects No in Row 1 for example, Row 2 and subsequent rows get greyed out. When user selects Yes in Row 1, Row 2 and subsequent ...
- 1
0
votes
0
answers
29
views
USB flash not working after PC turned off while formating [duplicate]
So I was using Rufus to put a copy of Windows 10 on a USB flash drive. The power suddenly cut and after the USB flash drive stopped working.
I tried some solutions but they fail, is the damage ...
0
votes
2
answers
43
views
Excel datetime format issue, possibly locale dependent
I'm working on a Belgian Excel 365 workbook. I have just imported a list of dates, looking like this:
dinsdag 5 december 2023 11:55:55
dinsdag 5 december 2023 11:55:56
dinsdag 5 december 2023 11:55:57
...
- 2,071
2
votes
1
answer
231
views
How can I zero out only the USED space on a storage drive?
I have a large drive (4TB) that I've only written a few gigabytes to. I'm giving it to a friend, so I'd like to zero it out. I know I can zero out the whole drive with dd, but I'd like to know if:
...
- 121
0
votes
1
answer
36
views
Excel - status (online/offline) corresponding to concrete number
I cannot deal with the below tasks, and need your help!
The thing is that I need to use a formula to solve this (not just copy-paste, assuming that the data will be much bigger). Basically, I need to ...
0
votes
0
answers
20
views
Auto Numbering in a single cell
I want a Cell to Auto-populate a Tracking # in a form that several people have access to on a shared drive. Example:
I open the Exception Form for the first time and it should show SL(date)-#:
result ...
0
votes
1
answer
67
views
Convert duration in XXm, YYs format to time value
In Microsot Excel, I have string data that represents duration of an event:
duration
40s
5m, 40s
59m, 59s
I need to convert the values to time (in adjacent column) so that I can format and sort ...
- 1,692
0
votes
0
answers
64
views
Why can't Windows 11 read properly the SSD which I connected to my laptop using a USB connector?
I wanted to wipe an SSD that was previously in a PC with Windows 11. I connected it via USB to my PC and Windows is telling me "A specified device does not exist". I checked it using "...
0
votes
0
answers
20
views
Best practice for repurposing a Windows 10 laptop for a charity [duplicate]
I have several laptops with Windows 10 installed which are BitLocker-encrypted. I am going to gift them to a charity and wondered if it was sufficient to use the in-built "Reset this PC" ...
1
vote
2
answers
136
views
Formatting of braces for C++ in Visual Studio Code
I've C/C++ extension of Microsoft as my default formatter. When I save/run my code the opening curly braces automatically move to newline instead of staying in sameline. How can I prevent this? (It ...
- 139
0
votes
0
answers
30
views
(Microsoft Word) How to stop styles opening in a box?
I'm trying to make some text be in the style of Header 1, Header 2, Header 3, etc
When I change the style of text, it opens up in this box instead of staying normal text that is in line with the rest ...
- 1
0
votes
1
answer
51
views
What are options to set up a new portable SSD for newer and legacy Windows computers?
I bought a new 4TB M.2 NVME and an external M.2 enclosure for it. I want to set this up to be used like portable storage (used like "flash" storage), so that it can be used on a new Win 11 ...
0
votes
0
answers
23
views
Cells number format breaks in one column only if multiple cells are moved
I have a table where I keep track of best times & corresponding dates in pairs of cells. Time on top with the date below it, stored in range [B3:E10]. The time values are entered into the formula ...
- 1
0
votes
0
answers
110
views
File System Unknown after decryption with Veracrypt Rescue Disk
My laptop had 2 veracrypt (1.25.9) disks (one as system, and the other with the same password) with windows installed in the first disk.
Suddenly it could´t boot anymore (May be it happened because, ...
- 1
-1
votes
2
answers
94
views
How to copy/paste cells from a conditionally formatted sheet to another file or sheet with formatting but without conditional rules?
I have an excel file "Book1" with conditional formatting enabled on "Sheet1".
Conditional rules are based on a formula.
For example, highlight the entire row blue if the value in ...
- 141
0
votes
1
answer
48
views
How can be column incluted into rows?
There is the table in MS Excel or LO Calc.
How can be it converted to this view of the table?
The transformation using links (within the same table) to the initial version is allowed.
- 1
0
votes
0
answers
54
views
ext4lazyinit and forcing to have similar times as an ext4 format time, advantages and disadvangages
I saw this question and while 2 years is a long time, can anybody share anything about any progress on ext4lazyinit. I am specifically interested in this statement by Ted Tso -
So that is what the ...
- 459
0
votes
2
answers
76
views
How do I format a target cell based on a source cell, using VBA?
I'm looking to copy the format of a cell within the table table1 to cells with matching text within the second table table2.
So for instance: NOT(H) is showing as green in table 1 and I want it to ...
- 1
0
votes
0
answers
447
views
Excel - paste *only* number formatting
Is it possible to copy/paste only number formatting in Excel.
There are various paste special options.
In particular Formulas/Number Formats and Values/Number Formats. But is there a way to paste only ...
- 263
0
votes
1
answer
65
views
Fill a cell when empty, and past a date in another column
I need a cell in column "B" to fill red, if it is empty and the date is past the date on column "M"
I have tried googling it, and there are no answers to help.
Thanks for your help
- 1
2
votes
0
answers
97
views
Stacked Area Chart Excel, 3 Series Negative Problems
I am trying to create a chart similar to this original chart. I'm having troubles with the negative values. The red area falls negative when I chart it as a stacked chart.
It seems like it should be ...
1
vote
0
answers
56
views
how to find the undesirable formatting in a presentation/slides such as bold or Symbol font
My manager told me he think in some places of my presentation file he noticed inappropriate formats such as bold and Symbol font. Is there an easy way, preferably free like in free beer way to search ...
- 137
0
votes
1
answer
78
views
Could I format my C: Drive by mistake?
Could you accidentally reformat a C: drive using file explorer? Would it be remotely possible?
I'm just wondering if this can happen - is it possible to accidentally click the format button on "...
- 109
1
vote
1
answer
362
views
How long do it take to fully format USB drive 2TB 2.0?
Since I can't find any answer from the internet, I hope someone will help me here.
I have just bought a 3.5$ USB drive 2TB 2.0. When I transfer my video file to the USB, the 3 first video is working ...
1
vote
2
answers
147
views
My SSD is acting like writing is locked. Not even bash dd command can achieve anything. How may I fix my drive?
I currently am using a 2.5" WD Blue 1Tb SSD for backups. I use Macrium Reflect on Windows to clone my C to it. Last time I attempted the clone, and because I don't do it often enough to remember ...
- 11
2
votes
1
answer
189
views
No drive letter assigned to USB, "Device not ready" on initialize attempt
I have a Toshiba 1TB external USB drive that I haven't used in a few years, but I'd like to use it now. Windows detects the USB, but doesn't assign a drive letter when I plug it in, regardless of ...
- 125
0
votes
3
answers
138
views
Data Formatting in Microsoft Excel: Cell formatting, Text formatting, and Number Formatting [closed]
Formatting text or numbers can make them appear more visible especially when you have a large worksheet.
Formatting in Excel is a simple process of modifying or manipulating data in spreadsheets from ...
user1806663
1
vote
0
answers
102
views
Excel VBA Macro: Formatting Duplicates and Uniques
I have a spread sheet where each row consists of information about a member of a group. In each cell of column B there is an integer that represents each person (i.e., think of an member ID). All ...
- 11
0
votes
1
answer
276
views
Remove formatting and partitions on a storage device
Under some circumstances, normal partitioning tools refuse do the requested work;
i.e. removing partitions, and deleting the partition table is troublesome...
How to get past this state? Please ...
- 9,038
0
votes
1
answer
141
views
Is there a way to create persistent bullets in Power Point?
I have added three custom bullets to the Style Master Text placeholder, however, I would like to have a choice to choose one of those three bullets on the fly. These come in a custom font.
This will ...
- 527
0
votes
1
answer
50
views
Change to Italic only one symbol in MS Word
I need to find all "ΔE" and change only "E" symbol to italic.
How can it be done by find and replace, because it make both ΔE italic?
Off course it can be done by changing all &...
- 300
0
votes
1
answer
651
views
Windows on a SSD recognized on one computer but not on another
A friend of mine asked me to install Windows on his new SSD. I use a dual boot system, with Ubuntu and Windows 10. I made a bootable flash USB of W10 so I could install it on his SSD, connected to my ...
0
votes
3
answers
109
views
Sd card was partitioned. Need it as 1
I have 64gb sd card. I put an ubuntu os on it. It failed to install. Went to format and overwrite to find it was partitioned. I tried diskmgmt. Tried right clicking on individual drives to delete them....
- 1
1
vote
2
answers
134
views
Formatting new identical HDDs, one taking way longer
I have recently purchased 2 identical HDDs:
Model Family: Seagate BarraCuda 3.5
Device Model: ST4000DM004-2U9104 (labeled as ST4000DMZ04)
Capacity: 4.00 TB [3.64 TiB, 4000787030016 bytes]
I've ...
0
votes
2
answers
108
views
why my hard drive is readonly? and how to fix it
I formatted my laptop
and now i am getting that my hard drive (D:) is read-only and I cannot partition it or copy any files on it.
I tried to add "Everyone" and gave that user full access ...
- 275
-2
votes
1
answer
27
views
How to use conditional formatting in excel for a crosstabbed table with multiple conditions?
I am having trouble in excel using conditional formatting for my table. I need to highlight the sample values that are greater than screening_1 or screening_2 for each individual row.If the value is ...
- 1
0
votes
2
answers
123
views
External Hard Drive Won't Format - Set to GPT/RAW
I'm trying to format an external hard drive, preferably to exFAT, but nothing is working.
If I check the details of the disk in diskpart, I get this:
And, this is what it looks like in disk ...
- 127
0
votes
0
answers
135
views
How to change all numbered paragraphs using one numbering format to another
Somehow, I have a Microsoft Word document with a lot of numbered paragraphs that aren't showing the intended number.
This seems to be because the document has a numbering format that's not actually ...
0
votes
1
answer
105
views
Formatting margins in Word documents
I am formatting a document written by someone else and am frustrated by the wandering margins. I have tried deleting all the margins and resetting but the problem remains. The ruler at the top of ...
- 1
1
vote
0
answers
84
views
Fixing "Bad Sectors" found during External HDD Formatting, Windows 10 CMD Prompt
I recently was trying to reformat a external 3TB WD MyBook (USB) via Windows Command Line
I used the command
C:\WINDOWS\system32>format g: /FS:NTFS /X
and received the following output
The type ...
- 49
0
votes
0
answers
96
views
Unformat HDD, windows / linux mess up
So i have an 8TB hard drive, was formatted in Ubuntu and was filled with data that i would give my little finger to be able to recover.
I recently installed Windows 11 in another SDD and when i opened ...
1
vote
1
answer
115
views
External hard drive "too big" for file transfer
I recently purchased a Samsung T7 Shield with a 4TB capacity to transfer surgical videos to from a Steris operating room camera. My computer is a MacBook Pro. I have been unable to transfer the videos ...
- 13
2
votes
0
answers
82
views
MicroSD Card Went From 512 GB to 30.6 MB
I have been using this card for the past 20 months without any problems. I was able to use all the memory (and even checked the card with H2testw with no errors). Recently I was using the card with a ...
- 123
0
votes
0
answers
810
views
Can't format nvme
I'm trying to install linux over a broken Windows 10 install.
I've booted on a live USB and tried to remove old partitions and format the disk, but everything I've tried until now failed.
If I try to ...
- 101
0
votes
1
answer
581
views
Conditionally formatting left align for a cell with text thats separated by multiple lines
I'm trying to write conditional formatting that will handle left aligning text in a cell that is normally in a range that's centered. The data in the cell could look like the following with each line ...
- 123
1
vote
1
answer
570
views
How can I get Excel to use conditional formatting per day of the week using dates and not the words "Monday, Tuesday,"
I am working on a delivery schedule for the company I work for and we want to be able to have the dates color coded by days of the week. But we often have several deliveries on the same date, so when ...
- 11
1
vote
0
answers
62
views
How to draw empty cell values in LibreOffice Calc
my problem is the following (didn't find info how to do it in the official documentation) - recorded ~108k ping results to LibreOffice table with columns
DATE (letter A),
LATENCY (letter B),
STATUS (...
- 177
0
votes
1
answer
2k
views
Removing outer white space around a bar graph
It might be a bit of a simple question but on
I want to remove the outer white space around the graph but I have no idea if its possible or how to do this. Any help woule be appreciated.
- 1
0
votes
2
answers
28
views
Excel - Total Count of multiple reasons
Ideally, I am looking for a solution where I can see the total number of reasons why the device failed, which is currently recorded in a dropdown list on excel (with option for multiple entries). When ...
0
votes
0
answers
9
views
SD partition reappears after delete [duplicate]
I have tried deleting the partitions on my SD card (Which is not hardware locked) using fdsik, gparted and the ubuntu formater. All confirm the deletion but after the deletion the partition reappears ...
- 1